Forum Discussion
Average
The easiest way to do this would be to add a card and slicer to do this. Are you looking for the table to stay static? If that is true, then you'll need to create time intelligent measures for each period you want to show. Attached an example file of the easy slicer and card way.
https://drive.google.com/open?id=1QNASArWgRyKaF7DBl7IzGfAEt9Z37bxU
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.