Forum Discussion

gvg's avatar
gvg
Icon for Post Prodigy rankPost Prodigy
9 years ago
Solved

How to make exclusion table in Power BI

I am looking for a solution of this probably simple problem. I have two tables in Power BI: Inventory and Sales:   Inventory                          Sales       Item   Title                      ...
Show and Tell
  • VP's avatar
    VP
    9 years ago

    Mearge or link both table and apply filter in visual (Quantity = Blank)

     

     

     

VP's avatar
VP
Icon for Most Valuable Professional rankMost Valuable Professional
9 years ago

Mearge or link both table and apply filter in visual (Quantity = Blank)

 

 

 

  • gvg's avatar
    gvg
    Icon for Post Prodigy rankPost Prodigy
    9 years ago

    OK, thanks. How do I link tables in Power BI? You mean establish relationship between the two tables?

  • VP's avatar
    VP
    Icon for Most Valuable Professional rankMost Valuable Professional
    9 years ago

    You can mearge in Query editor or Link in data model. Both options will give you same result