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.
Hi there,
I have this table in my model:
provider_id | year | time | sample | rate |
id1 | 2011 | 1 | 2 | 3 |
id2 | 2011 | 4 | 5 | 6 |
id3 | 2011 | 7 | 8 | 9 |
id1 | 2012 | 11 | 12 | 13 |
id2 | 2012 | 14 | 15 | 16 |
id3 | 2012 | 17 | 18 | 19 |
id1 | 2013 | 21 | 22 | 23 |
id2 | 2013 | 24 | 25 | 26 |
id3 | 2013 | 27 | 28 | 29 |
and I need to get this result table:
2011 | 2012 | 2013 | |||||||
provider_id | time | sample | rate | time | sample | rate | time | sample | rate |
id1 | 1 | 2 | 3 | 11 | 12 | 13 | 21 | 22 | 23 |
id2 | 4 | 5 | 6 | 14 | 15 | 16 | 24 | 25 | 26 |
id3 | 7 | 8 | 9 | 17 | 18 | 19 | 27 | 28 | 29 |
Is there any chance to achieve this through DAX?
Thank you for your time.
Adrian
Solved! Go to Solution.
Hi @adim,
Nope, dax is impossible to achieve this.
In my opinion, you can use original table column to create matrix visual with same result.
Regards,
Xiaoxin Sheng
Hi @adim,
Nope, dax is impossible to achieve this.
In my opinion, you can use original table column to create matrix visual with same result.
Regards,
Xiaoxin Sheng
Visual is fine but need this as intermediate table for calculations...(also unlock dynamic column selection!).
Why is this so hard? I am trying to get away from excel but some things like this are a huge nuisance to quick transfer of existing reports.
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |