Forum Discussion
Anders_G
Helper I
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...
Shahfaisal
Solution Sage
Solution SageThe 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