Forum Discussion

rwilcox's avatar
rwilcox
New Member
10 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    rwilcox

     

    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

  • MattAllington's avatar
    MattAllington
    9 years ago

    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]

pardeep657's avatar
pardeep657
Regular Visitor
9 years ago

so what is the solution? I tried IF(isblank([Country]),"USA",[Country]) it does not work.

DJPrometheus's avatar
DJPrometheus
Microsoft Employee
7 years ago

The correct answer if you have added a Custom Column is the following:

= if [country] is null then "USA" else [country]