Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
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?
Solved! Go to Solution.
This problem is solved. I had to create a date column and put in a slicer of the last 12 month
This problem is solved. I had to create a date column and put in a slicer of the last 12 month
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
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" ?)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |