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.
Hello,
I have a table which has same column name but each repeating column represents a service. Like if purchases column is coming first time it shows purchase of first service similarly if purchase column comes second time then it shows purchase of second service. I am attaching the table along with the outcome I want to have. I have tried unpivoting but did not get desired result.
My table look like below:
1 | 2 | 3 | |||||||
Client name | Purchase | AB//AC | Booking Date | Purchase | AB//AC | Booking Date | Purchase | AB//AC | Booking Date |
1 | $32,400 | AB | 28/12/2021 | ||||||
2 | $150,720 | AC | 30/09/2019 | $54,600 | AC | 23/10/2020 | $11,000 | AC | 18/12/2019 |
3 | $9,192 | AC | 05/02/2020 | $24,005 | AC | 02/02/2021 | $0 | AB | 18/02/2021 |
4 | $90,000 | AB | 02/11/2020 | $42,500 | AB | 24/09/2020 | $42,500 | AC | 26/09/2020 |
5 | $60,180 | AC | 01/09/2021 | $15,912 | AB | 02/12/2021 | |||
6 | $72,563 | AC | 20/03/2020 | $14,000 | AC | 14/04/2020 | $65,862 | AB | 31/03/2021 |
1,2,3 on top of column shows service for each like purchase for service 1, then 2 and then 3rd.
My outcome look like this:
Client name | Purchase | AB//AC | Booking Date |
1 | $32,400 | AB | 28/12/2021 |
2 | $150,720 | AC | 30/09/2019 |
3 | $9,192 | AC | 05/02/2020 |
4 | $90,000 | AB | 02/11/2020 |
5 | $60,180 | AC | 01/09/2021 |
6 | $72,563 | AC | 20/03/2020 |
1 | |||
2 | $54,600 | AC | 23/10/2020 |
3 | $24,005 | AC | 02/02/2021 |
4 | $42,500 | AB | 24/09/2020 |
5 | $15,912 | AB | 02/12/2021 |
6 | $14,000 | AC | 14/04/2020 |
1 | |||
2 | $11,000 | AC | 18/12/2019 |
3 | $0 | AB | 18/02/2021 |
4 | $42,500 | AC | 26/09/2020 |
5 | |||
6 | $65,862 | AB | 31/03/2021 |
It would be quite helpful if it is possible or not.
Thank you
Solved! Go to Solution.
I solved it using below video
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |