Forum Discussion
Average
I'm looking for a way to calculate the average over time for below highlighted column: The [Positive %] measure is simply Positive Count/Total Count for each month surveys were taken. Every...
I think I understand, without seeing your date table, it's tough to say exactly how to implement it. This article shows a good example of computing average over certain time frames.
https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/
BKirsch12 Thanks! I'll be sure to check it out and give it a try.