Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Coline
Frequent Visitor

DAX Rolling 12 month with no value in a month

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))

 

12MG.png

 

Can someone help me?

Thanks

 

0 REPLIES 0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.