How to generate Sales Data matrix for DealerType on Month on Monthwise

[chinma]

Team, I have data in the attached image format 

and I need to generate Rolling 12 month matrix for DealerType based on the year & month selected by user.  Sample output is in the attached image:

Please share a sample working solution. 

Greatly appriciate your assistance.

Thank you.

[Anonymous]

Hi,@chinma I am glad to help you.
Hello,@VijayP ,thanks for your concern about this issue.

Your answer is excellent!
Has your problem been solved? If your problem has been solved, please mark the suggestion to solve the problem as a solution!

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VijayP]

@chinma 

First thing you must have a date column
So Create a concatenated column using all the date parts in your data
Then you must have a date dimension table and connect that table to  your data table
Then you must use this DAX 
Calculate(sum(valuecolumn),

filter(allselected(datedimension),Datedimension[Date]<=max(Datedimension[Date]))

and you will get the required rolling 12 months