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