Forum Discussion
Power BI Merge SharePoint Lists with Contains
Hi, I have 2 SharePoint Lists 1. Accounts (with AccountNumber column has single Account Number for each row i.e. 22) 2. Cases (with AccountNumber column has multiple Account Numbers for each row ...
Thank you Chris for your reply. But that works if its exact match on AccountNumber right? In my case, I need it to work if the join on AccountNumber in Accounts list contains in AccountNumber in Cases list. I found this example on YouTube. Not sure if there is anything else besides this example.
https://www.youtube.com/watch?v=aXgHVXHRvd8