Showing results for 
Search instead for 
Did you mean: 
vinoo_sanchu Frequent Visitor
Frequent Visitor

If else then Otherwise in calculated column

Hello Guys. I am trying to create a new column using the following logic #"Added Conditional Column" = Table.AddColumn(#"Added Custom2", "Geo/Country", each if [project_custom_property_execution_territory_txt] <> null then [project_custom_property_execution_territory_txt] else [execution_country_txt]), However I build this column, for some reason, I am continuing to see null values where it should have pulled from the execution_country_txt column. Not sure what the issue is. Any help is deeply appreciated Thanks VR