Forum Discussion
Matrix Table
Hi All, I have data in the following format:
| Time | Country | Value |
| 3M | AU | 10 |
| 6M | AU | 20 |
| YTD | AU | 30 |
| 3M | UK | 50 |
| 6M | UK | 60 |
| YTD | UK | 70 |
| 3M | US | 90 |
| 6M | US | 100 |
| YTD | US | 110 |
I need to show the data in the following format in the matrix visual:
| Time | Value |
| AU | |
| 3M | 10 |
| 6M | 20 |
| YTD | 30 |
| UK | |
| 3M | 50 |
| 6M | 60 |
| YTD | 70 |
| US | |
| 3M | 90 |
| 6M | 100 |
| YTD | 110 |
Please help in letting me know what DAX measure should I use to create this Matrix values.
In the matrix visual:
Rows box: Country, Time (in this order)
Values box: Value
1 Reply
In the matrix visual:
Rows box: Country, Time (in this order)
Values box: Value