Forum Discussion

rschaudhr's avatar
rschaudhr
Icon for Resolver II rankResolver II
6 years ago
Solved

Calculated Column sum last 60 days

Here is the data below:   Date Index Data Calculated column - Data_Index 201801 1 100   201802 2 200   201803 3 50 350 201805 4 50 300 201806 5 400 500 201809...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

rschaudhr So, maybe:

Column =
  VAR __Min = [Date]-60
RETURN
  SUMX(FILTER('Table',[Date]<=EARLIER([Date]) && [Date]>=__Min),[Date])
  • rschaudhr's avatar
    rschaudhr
    Icon for Resolver II rankResolver II
    6 years ago

    Hi Thanks for the code. However, it is adding the dates not the data. I will see if I can modify it.