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
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
