Tags Sameperiodlastyear function to show the data till exact date
Tag: sameperiodlastyear function to show the data till exact date
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.