Forum Discussion
Solved
Help with "if column values do not match another column values then..."
Hi there, I'm hoping someone can please assist me with this M code I am trying to impliment: I have a small table called TableCR which has 5 values: 1-EXCELLENT 2-GOOD 3-FAIR 4-...
Hi EimearC
Might be simpler to add a Custom Column
if not List.ContainsAny(TableCR[RatingCheck], {[Rating]}) then "3-FAIR" else [Rating]then delete the old rating column and rename the new column you just created.
Phil
PhilipTreacy
Super User
Super UserHi EimearC
Might be simpler to add a Custom Column
if not List.ContainsAny(TableCR[RatingCheck], {[Rating]}) then "3-FAIR" else [Rating]
then delete the old rating column and rename the new column you just created.
Phil