Power BI Merge SharePoint Lists with Contains

[tiffblue12]

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!

[Anonymous]

Hi  @tiffblue12 ,

There different joins kinds, you may try NATURALINNERJOIN in your scenario. 

Reference:
NATURALINNERJOIN function (DAX) - DAX | Microsoft Docs

NATURALLEFTOUTERJOIN 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.

[tiffblue12]

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

[ChristianDGreat]

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