cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hu-ron Frequent Visitor
Frequent Visitor

someone help me with a formula to calculate this

  1. In the Sales query, add a custom column named Country Name which takes the value of the Countrycolumn when it is not null and the value of "USA" when the Country column is null.
1 REPLY 1
SonaliG_LeX Regular Visitor
Regular Visitor

Re: someone help me with a formula to calculate this

 

click on add column tab -> add conditional column -> it opens a conditional column dialog box .

you can now create the foresaid condition for the specified column.

 

for reference for the same you can view the video as per this path:

 

Power BI Desktop Data Transformations > Transforming Data using Power BI Desktop > Conditional Columns