Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 Item Quantity
123 Soap 124 5
124 Detergent 123 8
125 Toothpaste
126 Tooth brush
How can I make a Table visual that lists items not sold. I.e. I need to return:
Item Title
125 Toothpaste
126 Tooth brush
Solved! Go to Solution.
Mearge or link both table and apply filter in visual (Quantity = Blank)
Mearge or link both table and apply filter in visual (Quantity = Blank)
You can mearge in Query editor or Link in data model. Both options will give you same result
OK, thanks. How do I link tables in Power BI? You mean establish relationship between the two tables?
User | Count |
---|---|
94 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |