Forum Discussion
How to Unpivot merge columns
Hi, I have a set of data with merge "month" column. How to unpivot it to have the expected output?
Raw Data:
| Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21 | |||||||
| Name | Customer Count | Sales Amount | Customer Count | Sales Amount | Customer Count | Sales Amount | Customer Count | Sales Amount | Customer Count | Sales Amount | Customer Count | Sales Amount |
| A | 3 | 564566 | 8 | 789789 | 2 | 564566 | 3 | 789789 | 8 | 564566 | 2 | 789789 |
| B | 5 | 678678 | 6 | 345564 | 2 | 678678 | 5 | 345564 | 6 | 678678 | 2 | 345564 |
| C | 6 | 234234 | 3 | 232342 | 5 | 234234 | 6 | 232342 | 3 | 234234 | 5 | 232342 |
| D | 2 | 678678 | 5 | 567567 | 9 | 678678 | 2 | 567567 | 5 | 678678 | 9 | 567567 |
| E | 5 | 345345 | 2 | 345456 | 7 | 345345 | 5 | 345456 | 2 | 345345 | 7 | 345456 |
Expected Output:
| Name | Month | Customer Count | Sales Amount |
| A | Oct-20 | 3 | 564566 |
| B | Oct-20 | 5 | 678678 |
| C | Oct-20 | 6 | 234234 |
| D | Oct-20 | 2 | 678678 |
| E | Oct-20 | 5 | 345345 |
| A | Nov-20 | 8 | 789789 |
| B | Nov-20 | 6 | 345564 |
| C | Nov-20 | 3 | 232342 |
| D | Nov-20 | 5 | 567567 |
| E | Nov-20 | 2 | 345456 |
| A | Dec-20 | 2 | 564566 |
| B | Dec-20 | 2 | 678678 |
| C | Dec-20 | 5 | 234234 |
| D | Dec-20 | 9 | 678678 |
| E | Dec-20 | 7 | 345345 |
Hi,
Can you please check if attached PBIX file contains the solution you are looking for.
The steps that need to be applied are
1 Reply
FarhanAhmedCommunity Champion
Hi,
Can you please check if attached PBIX file contains the solution you are looking for.
The steps that need to be applied are