Forum Discussion

mehmetpowerbi's avatar
mehmetpowerbi
Regular Visitor
8 years ago

Left join in Power BI QNA

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

Need Help

4 Replies

  • mehmetpowerbi's avatar
    mehmetpowerbi
    Regular Visitor
    8 years ago

    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's avatar
    dilumd
    Icon for Impactful Individual rankImpactful Individual
    8 years ago

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

     

     

     

    • mehmetpowerbi's avatar
      mehmetpowerbi
      Regular Visitor
      8 years ago

      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's avatar
        v-huizhn-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        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