Forum Discussion

AOD's avatar
AOD
Icon for Helper III rankHelper III
5 years ago
Solved

7 Days Rolling calculation

Hi All,    Need help in calculating 7 days rolling DAX formula based on Value field. Thanks in advance for helping.    
DAX
Need Help
  • AnkitKukreja's avatar
    AnkitKukreja
    5 years ago

    Hi AOD 

     

    It depends what you want to achieve, but you can use dateadd, datesinperiod, etc functions for getting your results.

     

    Thanks,

    Ankit

AnkitKukreja's avatar
AnkitKukreja
Icon for Super User rankSuper User
5 years ago

Hi AOD 

 

It depends what you want to achieve, but you can use dateadd, datesinperiod, etc functions for getting your results.

 

Thanks,

Ankit

  • AOD's avatar
    AOD
    Icon for Helper III rankHelper III
    5 years ago
    Thanks. Got it resolved with below DAX
    Moving sum = CALCULATE(SUM(Sheet1[Value ]),
    DATESINPERIOD(Sheet1[Column3],LASTDATE(Sheet1[Column3]),-7,DAY)
    )