Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 written correctly but received an error value in every row once applied
Solved! Go to Solution.
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]
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
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
I went back in and added the original systax and it now works.
so what is the solution? I tried IF(isblank([Country]),"USA",[Country]) it does not work.
The correct answer if you have added a Custom Column is the following:
= if [country] is null then "USA" else [country]
User | Count |
---|---|
103 | |
87 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |