Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

3 month rolling calculation error

Hi, I have a 2 data sources and need to do some operations between them. I have created a sample to represent the real life solution that I need. Table Sales: dateSold Sector Idsale NPS ...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , You join it with the calendar table marked as date table and create measure like

 

example

 

Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi amitchandak, thank you for your reply!

     

    Actually, there is no issue on calculating the rolling 3 period, the issue is on multiplying it by the respective weight of its Sector, like I'm trying to do in FinalValue field.

    The rolling 3 is working fine, as done by the variables BAD, GOOD and TOTAL.