Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Rolling 12 months data

Hi amitchandak ,  I am using this measure for getting 12 months back data on my line chart but facing some issues in it. Rolling 12 Graph 2 = VAR _MAX = MAXX(ALLSELECTED('Date'),'Date'[D...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous 

     

    I see your requirement now, to explain the dax to get last 12 month, please see this example pbix. And change the return expression to Count().

     

    Paul Zheng _ Community Support Team
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous check this post, you can tweak as per your business needs.

 

https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous I also have a solution at this post, check it out.