Forum Discussion
Solved
Groupby with IF statement
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}
}
)
Robert14358, You can have it in 2 steps.
- Create a custom column with the if else condition
- Use the custom column in the group by
Share sample data and expected output for the right solution!
2 Replies
Robert14358, You can have it in 2 steps.
- Create a custom column with the if else condition
- Use the custom column in the group by
Share sample data and expected output for the right solution!
hmm okay, i wanted 1 step though 😞
