Relative Content

Tag Archive for powerbidaxrolling-average

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: