Forum Discussion
Helper INeed a sameperiodlastyear type formula to dynamically compare current and last year.
Hey there!
I'm in need of a dynamic same period last year comparison between 2022 and 2021. Currently my SAMEPERIODLASTYEAR formula returns the below results giving me a full last year comparison against the current year.
SUM LY Sameperiod = CALCULATE(sum('My Dataset'[Amount]), SAMEPERIODLASTYEAR('Date Table'[Date]))
I would like a formula that returns last year data for the same period as I have current year data ie. Jan 1 - Nov 23 for both 2022 and 2021. The report will update every day adding another day and it should be reflected in the report. I do not want to use manual filters like slicers.
Thank you very much!
1 Reply
ShahfaisalSolution Sage
The SAMEPERIODLASTYEAR function uses full period for comparison. Take a look at the solution provided in this article - https://radacad.com/same-period-last-year-to-date-dax-calculation-in-power-bi