Groupby with IF statement

[Robert14358]

Hello All.

I cant seem to get this to work:

= Table.Group(#"Changed Type", {"Block_ID"},
{
{"Children", each Text.Combine(each if [Block_type] = "Block" then [Block_Name_Child] else null, " | "), type text}
}
)

[SivaMani · Accepted solution]

@Robert14358, You can have it in 2 steps.

1. Create a custom column with the if else condition
2. Use the custom column in the group by

Share sample data and expected output for the right solution!

[Robert14358]

hmm okay, i wanted 1 step though 😞