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

IF then else conditional issue power BI query

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