Summarize rows in a calculated table

[TimPowerBi2]

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!

[Arul · Accepted solution]

@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

[TimPowerBi2]

This worked! Thank you so much highly appreciated.

[johnyip]

I 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.

[Gokul_G16]

Dear @TimPowerBi2 ,
Can you please try this below snap way over the Power Query level. 

Hope this have good on it.

Regards,
Gokul