Forum Discussion
Solved
Adding custom column
I am trying to write the if then statement for adding a new column. If the country column is null then return "USA" or return the value from the country column I thought I had the statement w...
Th formula for the NewCountryColumn should be like
=IF(isblank([Country]),"USA",[Country])
If this works please accept this as a solution and also give KUDOS.
Cheers
CheenuSIng
Are you doing this in Get Data or DAX? I recommend the former.
The if statement in Power Query is written as follows
= if [country] is null then "USA" else [country]
Are you doing this in Get Data or DAX? I recommend the former.
The if statement in Power Query is written as follows
= if [country] is null then "USA" else [country]