Left join in Power BI QNA

[mehmetpowerbi]

Hi all,

I  am experimenting with Power BI  Q&A.  However I couldn't figure out how to ask a proper question for illustrating Left JOIN scenario. 

Let me give you my sample scenario: I have [customer] and [customerproduct]  tables in my data set.   I would like to select [customers] who has "product-A"  but the don't have "product-B".

I have tried below phrases without any luck.

• Customers have A  but do not have B
• Customers who bought A  but not bought B
• Customers who haven't  B but have A

I appreciate if you can help me.

Thanks in advance

Mehmet

[mehmetpowerbi]

Hi all,

I  am experimenting with Power BI  Q&A.  However I couldn't figure out how to ask a proper question for illustrating Left JOIN scenario. 

Let me give you my sample scenario: I have [customer] and [customerproduct]  tables in my data set.   I would like to select [customers] who has "product-A"  but the don't have "product-B".

I have tried below phrases without any luck.

• Customers have A  but do not have B
• Customers who bought A  but not bought B
• Customers who haven't  B but have A

I appreciate if you can help me.

Thanks in advance

Mehmet

[dilumd]

Is it possible for you to try merge facility in power query?

 

[mehmetpowerbi]

Hi dilumd,

I need to use Q&A interface for this query.  Query editor is not an option.  I will provide sample queries to business users who doesn't have any SQL skills. I can't find any appropriate phrase to replicate Left Outer join in Power BI Q&A .

[v-huizhn-msft]

Hi @mehmetpowerbi,

Actually, you can do it in Power BI desktop as @dilumd said, then publish it to Power BI service. Then share the dashboard to your business users.

Best Regards,
Angelia