Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
daxer-almighty's avatar
daxer-almighty
Icon for Solution Sage rankSolution Sage
5 years ago

Yes, RELATED works in DQ as one can check in dax.guide. But why would you expect RELATED to throw an error? That is what bothers me a lot since this means you're not sure if there's going to be a relationship between the tables. By the by, one can easily remove RELATED and use LOOKUPVALUE instead.