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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi - I am looking for help on convert formula below in DAX. Thank you so much!
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)))
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
)
)
)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 9 | |
| 8 | |
| 7 | |
| 6 |