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 i.e. 22, 33, 44)
How do I merge the 2 SharePoint Lists on AccountNumber column with contains ...
Thank you in advance!
3 Replies
- ChristianDGreat
Resolver I
Connect to your two sources first, the go to Power Query and do a merge.
Other option is outside power query, basically if your on Power BI Desktop you can just use relationship to join the two.Thanks
Chris
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
Hi tiffblue12 ,
There different joins kinds, you may try NATURALINNERJOIN in your scenario.
Reference:
NATURALINNERJOIN function (DAX) - DAX | Microsoft DocsNATURALLEFTOUTERJOIN function (DAX) - DAX | Microsoft Docs
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
