Forum Discussion
DAX formula help
I have some data like this (here only shows the first 20 rows): This is raw data about each project year, each state, region, device has multiple events, and the value for each event is "Count" colu...
Hi,
For Question1, try this rolling average measure
=if(ISBLANK(MIN('Calendar'[Date])),BLANK(),divide('SAMPLE DATA'[Rolling12MonTotal], 12))
Hope this helps.
Hi Ashish_Mathur, thank you! It works for my question 1.
Any suggestion for question 2? Thanks!
You are welcome.