Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am using this measure to calculate last year sales:
Year 2023 | Months | Last Year Sales |
Total : 1000 | ||
January | 200 | |
February | 50 | |
March | 150 | |
Hi,
Try using SAMEPERIODLASTYEAR() instead of PREVIOUSYEAR().
I think that will solve your problem.
@AliNoorani it doesn't give total sales of last year, only shows last year's same month/period value. I need to show first total of last year then breakdown in the months.