Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 33 | |
| 31 | |
| 19 | |
| 12 | |
| 10 |