Forum Discussion

Anonymous

Not applicable

2 years ago

Solved

Writing simple IFERROR statement

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 th...

AnalyticPulse
2 years ago
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?

AnalyticPulse

Solution Sage

2 years ago

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?

Forum Discussion

Writing simple IFERROR statement

Related content

Learning to write DAX statements

Unable to write iferror syntax

IFERROR

IFERROR in DQ

How to write this IF statement for same date, but different statuses?