Forum Discussion
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...
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,
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous,
Could you please mark the proper answers as solutions?
Best Regards,