Forum Discussion
BishwaR
Helper V
Helper VConditional column with different datatype
I am creating a conditional column on numeric column but the out with a String. If Numeric Column A is < 0 then output N/A. When I tried it it creates the column but then while saving the q...
In the formula bar, type:
= Table.AddColumn(NameOfPriorStep, each if [Column A] < 0 then "N/A" else [Column A], type text)
--Nate
In the formula bar, type:
= Table.AddColumn(NameOfPriorStep, each if [Column A] < 0 then "N/A" else [Column A], type text)
--Nate