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, " ...
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!
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 😞
