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
Data Days 2026
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Power BI Monthly Update - May 2026
Check out the May 2026 Power BI update to learn about new features.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
