Do you want to compare your data from the same period last year in Power BI?

  • Simon Harrison

You can use the SAMEPERIODLASTYEAR function to do it easily and accurately. SAMEPERIODLASTYEAR returns a table of dates shifted one year back in time from the dates in your data, so you can compare the performance of your business or process over time. You can use it with other DAX functions and visuals to create various types of reports and dashboards. Check out our blog post to learn more about how to use SAMEPERIODLASTYEAR in Power BI https://www.selectdistinct.co.uk/2023/06/08/sameperiodlastyear-in-power-bi/ #PowerBI #DAX #TimeIntelligence #SAMEPERIODLASTYEAR