Forum Discussion
PowerBi add new column. value if blank
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"
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
4 Replies
- mahoneypat
Microsoft Employee
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
- amitchandak
Super User
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 - v-easonf-msft
Community Support
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
