Forum Discussion

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

Moving average last 90 days without using Date filter

Hi friends,  I created the moving average last 90 days measure:    Average L90D = CALCULATE([Quantity], Filter (all (D_Date), D_Date[Date] > max (D_Date[Date])-90 && D_Date[Date] <= MAX(D_D...
Need Help
  • tracytran91's avatar
    tracytran91
    5 years ago

    I found a trick to solve this problem: just set a relative 90 days date for date filter on filter panel. 

tracytran91's avatar
tracytran91
Icon for Helper III rankHelper III
5 years ago

I found a trick to solve this problem: just set a relative 90 days date for date filter on filter panel.