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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi
considering the title of the topic and the image below,
How i can solve this considering i dont want to delete rows with errors.
Solved! Go to Solution.
The fastest way is to select that column, click the dropdown next to Replace Values, and select Replace Errors. Replace them with 0 or null. The word "null" will show up as a value in italics, and is equivalent to a blank in DAX. A zero might be better, but your call.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThe fastest way is to select that column, click the dropdown next to Replace Values, and select Replace Errors. Replace them with 0 or null. The word "null" will show up as a value in italics, and is equivalent to a blank in DAX. A zero might be better, but your call.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingTy vry much