Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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" ?)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |