Forum Discussion
DAX create a table pivot like
I have the following case, I have a table containing the following info : BusField, Region, Sales1, Sales2, Sales3, Year B1, R1, 100, 200, 300, 2020 B1, R1, 200, 300, 200, 2021 B1, R1, 100, 200...
Original TEST table
| Business Field | Region | Year | Sales1 | Sales2 | Sales3 |
| THY | B | 2023 | 10 | 20 | 30 |
| THY | B | 2024 | 5 | 10 | 1 |
| THY | B | 2025 | 6 | 8 | 9 |
| THY | B | 2026 | 7 | 5 | 10 |
| CAR | B | 2023 | 11 | 21 | 31 |
| CAR | B | 2024 | 6 | 11 | 2 |
| CAR | B | 2025 | 7 | 9 | 10 |
| CAR | B | 2026 | 8 | 8 | 5 |
| after transform | |||||
| Business Field | SD Region BF | Type | 2023 | 2024 | 2025 |
| CAR | B | Sales1 | 11 | 6 | 7 |
| CAR | B | Sales2 | 21 | 11 | 9 |
| CAR | B | Sales3 | 31 | 2 | 10 |
| THY | B | Sales1 | 10 | 5 | 6 |
| THY | B | Sales2 | 20 | 10 | 8 |
| THY | B | Sales3 | 30 | 1 | 9 |