Hi
I run Excel 365 v2104 b13929.20386 where it appears DAX LOOKUPVALUE function does not accept the <alternateResult> argument
PBI Desktop
=LOOKUPVALUE('Product'[Product], 'Product'[ProductKey], 123, 0) // Works no problem
Excel PowerPivot
=LOOKUPVALUE('Product'[Product], 'Product'[ProductKey], 123, 0) // Not accepted
Error message
The number of arguments is invalid. Function LOOKUPVALUE must have a value for each specified column reference
Function doc.
The date (10/14/2020) seems to suggest either a doc. and/or a function revision/change by end of 2020
Does anyone have any info. regarding this and knows if it's currently expected that Excel PP doesn't support the <alternateResult> arg.?
Possible workaroud
VAR tryLookup = LOOKUPVALUE('Product'[Product], 'Product'[ProductKey], 123)
RETURN
IF( ISBLANK(tryLookup), 0, tryLookup)
Thanks

