Forum Discussion
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...
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.
Anonymous
How did you change [Score1] to a column? Can you provide the dax. Usually the dax for measure and column is different.
Please elaborate more with a sample pbix.
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.