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
    10 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
    10 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]

LiamCurham's avatar
LiamCurham
New Member
9 years ago

I tried this. I was allowed click OK on the formula but I then get an ExpressionError: The name "IF" wasnt recognised.

 

PS - I had to change my setting to US (even though I am in UK region) for previous part of Lab1 (I am doing the edX LAb) as it didnt recognise the Data format when importing CSV files, but I dont think this is related.

 

I also tried

 

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

 

but i wasnt able to click on the Ok button to accept the formula

LiamCurham's avatar
LiamCurham
New Member
9 years ago

I went back in and added the original systax and it now works.

  • 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]