Forum Discussion
Question about adding a new column and adding formulas
I am in the process of doing an intro Power BI course. In the training materials it says: "In the Sales query, add a custom column named Country Name which takes the value of the Country colu...
The following could work for you.
Country = IF(ISBLANK(Sales Query[Column]),"USA",Sales Query[Column])
If the cell is blank put in USA, if it is not then put in the value that is there. Need a bit more information though as not sure where the other country names are coming from.
Thanks,
Giles