Forum Discussion

monojchakrab's avatar
monojchakrab
Icon for Resolver III rankResolver III
4 years ago
Solved

Add date filter to 7 day moving average formula

Hiya All,   I have a 7 day moving average code as shown below : 7 day MA = CALCULATE( AVERAGEX(SUMMARIZE('Date Table', 'Date Table'[Date]), 'Measures tray'[Total Sales]), ...
Need Help
Show and Tell
PC2790's avatar
PC2790
Icon for Community Champion rankCommunity Champion
4 years ago

Did you try using the date from your Fact table instead of Dates Table?

As in LASTDATE(DatefromFactTable)