Forum Discussion

Ekaterina's avatar
Ekaterina
Regular Visitor
9 years ago

IF condition

Hello,   could anyone tell me what is wrong with the following statement:   Column = IF Query[CR] = NaN then 0 else Query1[CR]   Thank you, Ekaterina
Need Help
MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

= NaN won't work either in Power Query.

 

Working example query:

 

let
    Source = Table.FromList({1,#nan,2}, Splitter.SplitByNothing(), {"CR"}, null, ExtraValues.Error),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each if Number.IsNaN([CR]) then 0 else [CR])
in
    #"Added Custom"