Forum Discussion
3 month Rolling Average
Hello, I need help to create a Dynamic moving average of 3 months. My data has events per Client and data is heirachical based on Event Date Column. below is an example table of what i want to cre...
v-diye-msft
Community Support
Community SupportHi NMehta2
If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!
Hello v-diye-msft and ImkeF
i am still looking for a better alternative to what ImkeF has suggested. the issue is that by dividing by 3, i immediately get the first month divided by 3 and that is not what i want. Quick measure gives me incorrect values (does not consider null values) and dividing by 3 gives me a wrong start of the data
Still looking for a DAX that will help me the correct values as indicated in the table above - COL B in BOLD