Forum Discussion
Solved
Create single table with multiple columns
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...
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.