Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |