Forum Discussion

cristianj's avatar
cristianj
Helper IV
3 years ago
Solved

Need help with formula

Hello i have this  model date cant modelid     model1 01.01.2022 1 mod01     model2 03.01.2022 2 mod02     model3 10.01.2022 4 mod03     model4 15.01.2022 2 mod...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    cristianj , Join the date of table with date of date table and try a measure like example

     

    Rolling 30 = CALCULATE(Average(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-30,DAY))

     

    refer, if needed

    Rolling Days Formula: https://youtu.be/cJVj5nhkKBw

amitchandak's avatar
amitchandak
Super User
3 years ago

cristianj , Join the date of table with date of date table and try a measure like example

 

Rolling 30 = CALCULATE(Average(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-30,DAY))

 

refer, if needed

Rolling Days Formula: https://youtu.be/cJVj5nhkKBw