Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

7 Day Moving Average not working correctly

Hi All, I am creating a report using SSAS Tabular live connection. Client wants to report all the measures should be created in cube itself. I tried 7 Day Avg below measure in cube, it is not giv...

Need Help

v-jiascu-msft
7 years ago
Hi Anonymous,

It looks like a context issue. If you put the [GasProduction(sum)] and the [Rolling 7 day SUM] along with the [Production Date], I think you will get the right result.

I would still suggest you create a date table. The dates in the visual will be from this table.

Calendar = calendar(date(2010, 1,1), date(2019, 12, 31))

Best Regards,