Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I'm trying to apply a sameperiolastyear function but is not working, this is my DAX:
Solved! Go to Solution.
Hi @JEM_Systems ,
I suggest you to create a calendar table with continuous date by CALENDAR()/CALENDARAUTO() function.
Calendar = ADDCOLUMNS(CALENDARAUTO(),"Year",YEAR([Date]))
Measure:
LY Sales = CALCULATE(SUM('Table'[Sales]),SAMEPERIODLASTYEAR('Calendar'[Date]))
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @JEM_Systems - we would need a lot more info than that. How specifically is it not working? What kind of error does it return? Providing screenshots would help
Hi @JEM_Systems ,
I suggest you to create a calendar table with continuous date by CALENDAR()/CALENDARAUTO() function.
Calendar = ADDCOLUMNS(CALENDARAUTO(),"Year",YEAR([Date]))
Measure:
LY Sales = CALCULATE(SUM('Table'[Sales]),SAMEPERIODLASTYEAR('Calendar'[Date]))
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |