Thanks for looking into the query.
I have below data
| ID | Latest_updated_Date__c | Last_update_Date_1__c | Last_update_Date_2__c | Last_update_Date_3__c | Last_update_Date_4__c | Last_update_Date_5__c | Latest_Stage__c | Last_update_stage_1__c | Last_update_stage_2__c | Last_update_stage_3__c | Last_update_stage_4__c | Last_update_stage_5__c | Amt |
| 122333 | September 5, 2023 | August 20, 2023 | August 5, 2023 | July 20, 2023 | July 5, 2023 | A | A | A | A | A | 16 | ||
| 122334 | September 5, 2023 | August 20, 2023 | August 5, 2023 | July 20, 2023 | July 5, 2023 | B | A | A | A | A | 16 | ||
| 122335 | September 5, 2023 | August 20, 2023 | August 5, 2023 | July 20, 2023 | July 5, 2023 | A | A | A | A | A | 13 | ||
| 122336 | September 5, 2023 | August 20, 2023 | August 5, 2023 | July 20, 2023 | July 5, 2023 | A | A | A | A | A | 9 | ||
| 122337 | September 5, 2023 | August 20, 2023 | August 5, 2023 | July 20, 2023 | July 5, 2023 | C | A | A | A | A | 4 | ||
| 122338 | September 5, 2023 | August 20, 2023 | August 5, 2023 | July 20, 2023 | July 5, 2023 | B | B | B | B | 9 | |||
| 122339 | September 5, 2023 | August 20, 2023 | August 5, 2023 | July 20, 2023 | July 5, 2023 | A | A | A | A | A | 4 | ||
| 122340 | September 5, 2023 | August 20, 2023 | August 5, 2023 | July 20, 2023 | July 5, 2023 | B | A | A | D | D | 15 |
I have created seperate tables as below with the same.
As the stages are common in all the tables above, How can I create a single table where the Stage column will come only once, There will be multiple date columns with amt as below-
Step 1: I select 2 columns and merge with space.
Step 2: I change column name, "Date Stage 0".
Step 3: I do same steps for other columns.
Step 4: I select "Date Stage 0"-"Date Stage 5" and pivot...
Step 5: I separate a column with space.
Step 6: I change 2 names of columns.
Step 7: I go to Power BI Desktop and make matrix.
Step 1: I select 2 columns and merge with space.
Step 2: I change column name, "Date Stage 0".
Step 3: I do same steps for other columns.
Step 4: I select "Date Stage 0"-"Date Stage 5" and pivot...
Step 5: I separate a column with space.
Step 6: I change 2 names of columns.
Step 7: I go to Power BI Desktop and make matrix.
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
