Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to implement left outer join in Power BI

How can we implement left outer join with Power Bi during datamodelling?

I want to implement same functionalities like that in Qliksense or Crystal Reports

Need Help
Show and Tell

5 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

    Hi Anonymous 

     

    Plesae see the below example where Product is on jour left side.

    Regards,
    Mariusz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago


      Hi Mariusz  we have this m to n connection with SCD and Fosa data.But I want to have SCD to Fosa many to 1 connection which is currently not permitted.

      • Mariusz's avatar
        Mariusz
        Community Champion
        7 years ago

        Hi Anonymous 

        You can reate dimension table that can be used to filter both tables

         

        Regards,
        Mariusz

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.