Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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-
Solved! Go to Solution.
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.
User | Count |
---|---|
74 | |
73 | |
39 | |
25 | |
24 |
User | Count |
---|---|
96 | |
93 | |
51 | |
43 | |
42 |