Forum Discussion
Lookup which includes multiples, duplicates and null values
Thank you for your help, sorry I'm not good at posting stuff including links etc... I think the answer is
Column = IF(ISBLANK('Trial Balance'[SourceTransaction.UID]),FALSE(),IF(ISBLANK('Trial Balance'[UID]),FALSE(),CONTAINS('Trial Balance','Trial Balance'[UID],'Trial Balance'[SourceTransaction.UID])))... but i'm still testing it. thank you!
Hi Anonymous,
is this what you're after?: https://www.thebiccountant.com/2018/08/12/how-to-do-a-real-vlookup-false-in-power-query-or-power-bi/
Thanks I did find that one and try it, didn't work for me unfortunately. Your blogs are always excellent!!!
Problem is, that I still don't understand your request.
So unless you're providing real sample data of your desired result (full table like described here for exammple: https://social.technet.microsoft.com/wiki/contents/articles/28212.how-to-ask-a-power-bipower-querypower-pivot-question-to-get-a-prompt-accurate-and-helpful-response.aspx ) I cannot help you any further here.
Thank you for your help, sorry I'm not good at posting stuff including links etc... I think the answer is
Column = IF(ISBLANK('Trial Balance'[SourceTransaction.UID]),FALSE(),IF(ISBLANK('Trial Balance'[UID]),FALSE(),CONTAINS('Trial Balance','Trial Balance'[UID],'Trial Balance'[SourceTransaction.UID])))... but i'm still testing it. thank you!