Forum Discussion

TimPowerBi2's avatar
TimPowerBi2
Frequent Visitor
3 years ago
Solved

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...
Need Help
  • Arul's avatar
    Arul
    3 years ago

    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

Arul's avatar
Arul
Super User
3 years ago

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's avatar
TimPowerBi2
Frequent Visitor
3 years ago

This worked! Thank you so much highly appreciated.