Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |