Forum Discussion
Lookup value based on multiple criteria.
hi guys, I have this formulated column to gather some values from a table into another depending on a single criteria: Last AIF VA MCLS = calculate(FIRSTNONBLANK('Last Observation VA Mcls'[A...
Hi Anonymous,
You could have a good look at this video LOOKUPVALUE with multiple columns first.
If you still need help, could you share some data sample which your reproduce your scenario and your desired output, so that we can help further investigate on it?
Best Regards,
Cherry
Hi Cherry,
yes I did and those solution didn't worked at all. That's why I used the Filterall alternative. I looked at several "LOOKUPVALUE" tutorials but they led me nowhere.