Forum Discussion
Rolling average for categories.
i want to display data in the following format -
Department - April - March - February - January - 6M rolling aerage.
When i use the already created measure in the above scenario, it produces one extra column for each month. Even values are not correctly calculated. Can you please help me understand why the measure fails.
Super UserDo you have a date table or is it all coming from one table? If its all in one table then you'll need to create a proper date table. Plenty of articles and videos about that.
It was all coming from a single table. But i can create a date table. How to proceed after creating the date table?
- johnt75
After you've got the date table link that to your fact table and change the definitions of any measures to use the date table instead of the fact table. Also change the visuals to use columns from the date table. It should just work then.
As you suggested, i used a separate date table and made changes to the formula. It is still giving the same result. Why is it so hard to do simple things in DAX? As shown in below picture, i want to see last three months incidents department wise and 6 month moving average. Instead of total column i want to see RA6M. Can you please help me understand the solution?
I created some dummy data in excel like below.