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