PowerBi add new column. value if blank

[Anonymous]

HI,

Am trying to add a new column in Powerbi, by extracting the data from another column, if the extrated data is blank, i need to do another type of extraction.

Am trying with the following, which is not working and getting  error like "IF wasn't recognized"

[Anonymous]

[v-easonf-msft]

Hi , @Anonymous 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.
It will help other community members easily find the solution when they get the similar issue.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Anonymous  do not use ( after if

example

New Margin = ((if [Item.Brand] = "Brand 1" then 5 else  
		if [Item.Brand] = "Brand 2" then 5.5 else 
		if [Item.Brand] = "Brand 3" then 6.0 else 
		if [Item.Brand] = "Brand 4" then 6.5 else 
		7.0 )*([Qty]*[Price]) *((100-[Discount Percent])/100))/100

[mahoneypat · Accepted solution]

M is case sensitive and the if syntax is different in the query editor (M) than it is in DAX - IF(  ).  You need to use lower case and have 

if ... then ... else

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat