Solved: If Is number function

isamchakur · ‎02-11-2019

Hey guys,

I have a column with both text and numbers, and I need to perform a calculation only for the numbers. I have tough at

if (Value.Is(Value.FromText([ColumnOfMixedValues]), type number) then [#"PCE (ug/L)"]/165.83). Why that doesn't run?

v-jiascu-msft · ‎02-12-2019

You need to escape the special characters in the column name. Please try this one.

if Value.Is(Value.FromText([ColumnOfMixedValues]), type number) then [#"#""PCE (ug/L)"""]/165.83 else 0

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-jiascu-msft · ‎02-12-2019

Hi @isamchakur,

You need to escape the special characters in the column name. Please try this one.

if Value.Is(Value.FromText([ColumnOfMixedValues]), type number) then [#"#""PCE (ug/L)"""]/165.83 else 0

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.