Forum Discussion
Solved
DAX pivoting table
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
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
2 Replies
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.
