Forum Discussion
Solved
Splitting a list
Hi, fairly new to all of this so I am sure there are easier ways to do what I am trying to do. Right now I will settle for any old way though, having tried for ages with no luck. I have a debtors ag...
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)
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)