Forum Discussion
Solved
How to get an average for the previous 12 months dynamically
Evening gentlemen, I have this problem and I am not sure how to approach it. I have a table full of consumer complaints for our company, ofcourse the consumer complaint has a submission date. One...
Hi,
Your data table seems fine. You will need a schema like so:
Date 1-to-* complaints table
Date 1-to-* volume product table
And then to calculae the 12 month average, look at this article:
https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/
Hi,
Your data table seems fine. You will need a schema like so:
Date 1-to-* complaints table
Date 1-to-* volume product table
And then to calculae the 12 month average, look at this article:
https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/