Forum Discussion
PowerQuery lookup in same table not working
Hi, I am trying to match a value in same table from a different column but i keep getting an error Here is the formula im trying (trying to look up value in Column ContactLookup = if List...
Hi Mahmed1
What error is returned?
DateToText([Date])&[agentName] DateToText is the function Date.ToText? Is the result returned by the above code a text type?
Try:
= if List.PositionOf([ContactLookup], DateToText([Date])&[agentName]) > -1 then DateToText([Date])&[agentName] else ""List.PositionOf The first parameter is the type of a list.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum