Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
Solved! Go to 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
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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 6 | |
| 5 | |
| 5 |
| User | Count |
|---|---|
| 24 | |
| 11 | |
| 9 | |
| 9 | |
| 8 |