Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |