Forum Discussion
Summarize rows in a calculated table
Hello community!
I have an issue that seems really simple but because it is based on calculated columns to a calculated table I cannot use the Power Query Editor (as far as I know).
What I am trying to do is the following:
- I have table 1 in which I created a calculated column to find the earliest date for each name at each step
- now I want to create a new table in which I only get this earliest date column for each step for each name in one row
- however when I try to do that I keep on getting multiple rows for each earliest date
- what I want is to combine the multiple rows for each name into one row so I can easily compare the earliest dates
Below you can find some pictures to illustrate what I am trying to do. The code I used to get the Current Situation example is the following:
table 2 = summarizecolumns( table1[name] , table1[earliestdatestep1], table1[earliestdatestep2],table1[earliestdatestep3])
It seems as an easy thing to do but I got stuck on it. Help would be greatly appreciated!
TimPowerBi2 ,
I hope this might help you.Calculated Table = SUMMARIZE ( 'Table', 'Table'[Name], "Step 1", MAX ( 'Table'[Step 1] ), "Step 2", MAX ( 'Table'[Step 2] ), "Step 3", MAX ( 'Table'[Step 3] ) )Thanks,
Arul
4 Replies
TimPowerBi2 ,
I hope this might help you.Calculated Table = SUMMARIZE ( 'Table', 'Table'[Name], "Step 1", MAX ( 'Table'[Step 1] ), "Step 2", MAX ( 'Table'[Step 2] ), "Step 3", MAX ( 'Table'[Step 3] ) )Thanks,
Arul
This worked! Thank you so much highly appreciated.
Dear TimPowerBi2 ,
Can you please try this below snap way over the Power Query level.Hope this have good on it.
Regards,
GokulI believe you cn try creating your calculated table and column into PowerQuery-equivalent version, and then continue do the data processing in PowerQuery until your data meets your need.
