31.1 C
Delhi
Sunday, October 2, 2022
Tags Sameperiodlastyear function to show the data till exact date

Tag: sameperiodlastyear function to show the data till exact date

How to get the Same Period Last Year to Date in Power BI

0
Microsoft Power BI has an inbuilt Time Intelligence function, SAMEPERIODLASTYEAR, to return a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context. But this function has some limitations and does not return the exact date range in some scenarios. In this post, we will discuss the limitation and find the solution so that this Time Intelligence function can return the date range accurately to calculate the performance metrics.

Follow Us

151FansLike
42FollowersFollow
31,300SubscribersSubscribe