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
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Anonymous 

    Please see the link to the Video below, 

    https://www.youtube.com/watch?v=WUhjxQAiWRg

     

    Regards,
    Mariusz

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

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

do you have any link for this kind of solution.Here SCD is like a central fact table and hence I want to make it in a many to 1 relationship

  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

    Hi Anonymous 

    Please see the link to the Video below, 

    https://www.youtube.com/watch?v=WUhjxQAiWRg

     

    Regards,
    Mariusz

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