Forum Discussion
IFERROR in Dax
Formatting Excel formula from this post for the reader:
=IFERROR(
IF(
VLOOKUP(
M4285,
'Revenue Category Lookup'!$D:$G,
2,
FALSE
),
Q4285 & "-" & M4285,
"MISSING SPLIT BY"
),
IFERROR(
IF(
VLOOKUP(
K4285,
'Revenue Category Lookup'!$D:$G,
3,
FALSE
),
Q4285 & "-" & K4285,
"MISSING SPLIT BY"
),
IFERROR(
IF(
VLOOKUP(
I4285,
'Revenue Category Lookup'!$D:$G,
4,
FALSE
),
Q4285 & "-" & I4285,
"MISSING SPLIT BY"
),
Q4285 & "-" & S4285
)
)
)