Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Dynamic Rolling 3 Month Sum

Hi all, Having the below table, I want to be able to filter by month and have the 3 month rolling sum automatically update as a card visual.   month lead_cnt total_3month 202312 0 600 ...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file whether it suits your requirement.

     

     

     

     

     

    total 3 months measure: = 
CALCULATE (
    [lead cnt measure:],
    DATESINPERIOD ( date_table[Date], LASTDATE ( date_table[Date] ), -3, MONTH )
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file whether it suits your requirement.

 

 

 

 

 

total 3 months measure: = 
CALCULATE (
    [lead cnt measure:],
    DATESINPERIOD ( date_table[Date], LASTDATE ( date_table[Date] ), -3, MONTH )
)

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you, this is exactly what I needed.