Forum Discussion
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}
}
)
Anonymous, 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
SivaManiResident Rockstar
Anonymous, 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!