Forum Discussion
Resolver IMultiple conditons in conditional column
Thanks.
I tried using an "and" clause but it didn't work... the entries with "General Inc" all ended up as "Misc". I thought I had the "and" clause wrong, but the problem (aparently) was a space character in the Fund Name field. When I modified the Remove Duplicates to include a trim of the Fund Name, it worked....
= Table.TransformColumns(#"Removed Duplicates",{{"Fund Name", Text.Trim, type text}})
Super UserHi newhopepdx
If i understood correctly the needed logic than you can use custom column with the syntax :
if [Fund Name]="General Inc" and [Class]="General" then "General"
else if [Fund Name]="Misc Inc" and [Class]="General" then "Misc"
else "null"
if not, you can modify it as you need, this is a good "template".
You can download the file and follow my steps from This link
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Resolver IThanks.
I tried using an "and" clause but it didn't work... the entries with "General Inc" all ended up as "Misc". I thought I had the "and" clause wrong, but the problem (aparently) was a space character in the Fund Name field. When I modified the Remove Duplicates to include a trim of the Fund Name, it worked....
= Table.TransformColumns(#"Removed Duplicates",{{"Fund Name", Text.Trim, type text}})