Forum Discussion
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 the info on syntax on the learn.microsoft.com site
Hello Anonymous
try this formula
NewColumn = IFERROR(DIVIDE(Table[cell1], Table[cell2]), 0)
learn Microsoft PowerBI tool free:
Blog: AnalyticPulse
Youtube Channel: AnalyticPulseCase 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
1 Reply
Hello Anonymous
try this formula
NewColumn = IFERROR(DIVIDE(Table[cell1], Table[cell2]), 0)
learn Microsoft PowerBI tool free:
Blog: AnalyticPulse
Youtube Channel: AnalyticPulseCase 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