30.1 C
Sunday, September 25, 2022
Tags Sameperiodlastyear

Tag: Sameperiodlastyear

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

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