Forum Discussion
Splitting a list
It's all case sensitive.
Your Group by text needs to be Group By - So try the following -
= Table.AddColumn(#"Filtered Rows", "Custom", each if Text.Contains([Column1], "Group By") then [Column1] else null)
Hey dude,
Hopefully, this will work
Go to
Add Column > Conditional Column
" If "Customer" "Contains" Value "Group By " The Output "Customer" Else "null" (see below)
After you've done that, just go to:
Transform > Fill > Fill down
Let me know if that works.
If this post helps, then please consider Accept it as the solution to help the other members find it
Thanks. Really simple when its put there! But for some reason I am doing that and getting nulls in every row, including the rows Group by Rep. This is the code that following those steps results in:
= Table.AddColumn(#"Filtered Rows", "Custom", each if Text.Contains([Column1], "Group by") then [Column1] else null)
It's all case sensitive.
Your Group by text needs to be Group By - So try the following -
= Table.AddColumn(#"Filtered Rows", "Custom", each if Text.Contains([Column1], "Group By") then [Column1] else null)