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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.