DAX – PowerBI – Rolling 3 Month Average Measure for Clustered Bar Line Chart
I have tried every solution from similar questions and none have worked thus far.
I have a table of individual IDs, their Date, and an Action Indicator (0 or 1).
I created a clustered bar and line chart that has the total count of IDs for each month as the bar, and their average action rate as a line.
I want a measure that will create a trailing 3-month average line for the action rates. The closest I have gotten so far is:
Power BI DAX Calculate Moving Average While Ignoring Weekdays From Date Hierarchy
I am trying to create a moving average measure that gives me the moving average per month. My data has weekday as lowest level; however for this specific measure (and visual) I do not want the weekdays to have an impact.
Power BI DAX Calculate Moving Average While Ignoring Weekdays From Date Hierarchy
I am trying to create a moving average measure that gives me the moving average per month. My data has weekday as lowest level; however for this specific measure (and visual) I do not want the weekdays to have an impact.