Forum Discussion
Solved
LookupValue not returning all values
I've come across an interesting behaviour with the LOOKUPVALUE DAX, where it is not returning all lookupvalues, even though it should. Has anyone seen this before? Effectively, I am using the LOOKUPV...
What made you use LOOKUPVALUE in the first place if you have other options? It should only ever be used as a last resort.
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Hi ExcelMonke ,
Could you please provide more details about issue? Such as formulas and screenshots. It would be better to provide a demo file.
Best regards,
Mengmeng Li