Forum Discussion

harshadrokade's avatar
harshadrokade
Post Partisan
2 years ago
Solved

Create single table with multiple columns

Thanks for looking into the query.

 

I have below data

IDLatest_updated_Date__cLast_update_Date_1__cLast_update_Date_2__cLast_update_Date_3__cLast_update_Date_4__cLast_update_Date_5__cLatest_Stage__cLast_update_stage_1__cLast_update_stage_2__cLast_update_stage_3__cLast_update_stage_4__cLast_update_stage_5__cAmt
122333September 5, 2023August 20, 2023August 5, 2023July 20, 2023July 5, 2023 AAAAA 16
122334September 5, 2023August 20, 2023August 5, 2023July 20, 2023July 5, 2023 BAAAA 16
122335September 5, 2023August 20, 2023August 5, 2023July 20, 2023July 5, 2023 AAAAA 13
122336September 5, 2023August 20, 2023August 5, 2023July 20, 2023July 5, 2023 AAAAA 9
122337September 5, 2023August 20, 2023August 5, 2023July 20, 2023July 5, 2023 CAAAA 4
122338September 5, 2023August 20, 2023August 5, 2023July 20, 2023July 5, 2023 BBBB  9
122339September 5, 2023August 20, 2023August 5, 2023July 20, 2023July 5, 2023 AAAAA 4
122340September 5, 2023August 20, 2023August 5, 2023July 20, 2023July 5, 2023 BAADD 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-

 

 

Need Help
  • mickey64's avatar
    mickey64
    2 years ago

    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.

     

     

1 Reply

  • mickey64's avatar
    mickey64
    Super User
    2 years ago

    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.