Matrix table of the last 12 month

[SvenJ]

Is ist possible to creat a matrix table of the last 12 month like this

Product

Jan 22

Feb 22

Mrz 22

Apr 21

Mai 21

Jun 21

Jul 21

Aug 21

Sep 21

Okt 21

Nov 21

Dez 21

A

B

C

D

I have a table wich gives me the column value "month f.ex. (1,2,3,4,5)" and a column wich gives me the year. Can i get it down, to get the 12 last month like the example above?

[SvenJ · Accepted solution]

This problem is solved. I had to create a date column and put in a slicer of the last 12 month

[Anonymous]

Hi @SvenJ ,

It's glad to hear that your problem has been resolved. And thanks for sharing your solution here. Could you please mark your post as Answered since it has been resolved? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

Best Regards

[lbendlin]

needs more details. What do you plan to fill the table with?  Will there be gaps in the data?  (ie do you need to use disconnected tables an cross joins, or is your fact table "filled enough" ?)