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.
I would like to do a comparison for sales current year and last year. However, 29/2/24 last year sales returned to 28/2/23.
29/2/24 LY sales suppose to return as 0.
My measure is
Is there a way to show 0 on 29/2/24 Last year sales?
Best Regards,
Sosot
For a true "Same Period Last Year" calculation subtract 364 days. That will work in all years, including leap years, and will get you closer to a "like for like" comparison.
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
93 | |
91 | |
91 | |
76 | |
70 |