Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Power BI Relationship between two tables

I have 2 tables T1 and T2 and they related to each other using T1(1-*)T2.  Now I wanted to show the rows from T1 where I couldn't find atleast one row in T2.  Using SQL I could write something like...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous

 

One way is to new a table with EXCEPT Function . The other way is to use Merge Queries in Query Editor. For example:

Regards,

Cherie