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'm blocked on my Sum Rolling 12 months measure:
When I want to split by category, it's possible to have no value in the last month that I want to begin the 12 months, in this case, the Rolling 12 months doesn't sum with the previous 11 months.
In this example, line 5, I have nothing, or I have to have 4. It's because I want the rolling for November, and in november I have no value for line 5.
My measure:
A 12MG = CALCULATE([A];
DATESINPERIOD('Date'[Date];
LASTDATE('Date'[Date]);-12;MONTH))
Can someone help me?
Thanks