Forum Discussion
Workaround for IFERROR in DAX using DirectQuery
I'm currently migrating a PBI report from Import mode to DirectQuery. But apparently this mode doesn't have IFERROR. Is there another function/workaround for this issue? The column is defined as foll...
amitchandak
Super User
Super UserAnonymous , Try like
value =
VAR z = MINX('Table2',
MAXX('Table2',
IFERROR(
RELATED('Table'[x]),
BLANK()),
0.1),
10000000)*[y]
RETURN IF(z>=2000,
ROUND(z,-2),
IF(z>1,
ROUND(z,0),
IF(z=0,
0,
1
)
)
)
I tried to remove the numbers on the MAXX and MINX, now both functions have 2 arguments. But the error is:
OLE DB or ODBC error: Exception from HRESULT: 0x80040E57