Writing simple IFERROR statement

[Anonymous]

I'm new to DAX and need to replicate an IFERROR formula from Excel that is =IFERROR(+cell1/cell2,0). I keep messing things up with not only the absolute value statement as well as the IFERROR from the info on syntax on the learn.microsoft.com site

[AnalyticPulse · Accepted solution]

Hello @Anonymous 

try this formula 

NewColumn = IFERROR(DIVIDE(Table[cell1], Table[cell2]), 0)

learn Microsoft PowerBI tool free:

Blog: AnalyticPulse 
Youtube Channel: AnalyticPulse

Case Study: Banking and Finance dashboard (Step by step guide)

Case Study: PowerBI Dashboard Developer for Sales Visualization

Commercial Real Estate Portfolio Overview by DataFreedom

Superstore Sales 2022 vs 2023: Year-on-Year Performance Comparison

dashboard by Manucaj

What If the Sun Disappeared?