Forum Discussion
Solved
Default value in M Query
Hi All, I have a column where a value is fixed,i am using custom column for this,but its showing error. Below is the Query where i am trying to make a validation in the column if it has the valu...
This should be done with Text.Contains instead of List.Contains:
= Table.AddColumn(PriorTableOrStepName, "Validator", each if Text.Contains([Column1], "Z") then "Valid" else "Invalid", type text)
--Nate
This should be done with Text.Contains instead of List.Contains:
= Table.AddColumn(PriorTableOrStepName, "Validator", each if Text.Contains([Column1], "Z") then "Valid" else "Invalid", type text)
--Nate