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...
BKirsch12 I was hoping to do it through DAX. The table was just meant to show the setup. Using the same dataset, I've accomplished this with another measure that was tracking something different:
So here the Month End column actually comes from my Date table. This works, so I attempted to do the same thing with the Positive % measure, but when I do every line comes back as 1.0 or 100%.
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.