Forum Discussion
Look up data based on multiple conditions
Hi.
Thank you for your advise.First I am reaching out to the once who manage the Power BI semantic model, and asking them to append the tables.
Hopefully they will do it, as it will be very time consuming and maintenance heavy to make measures for each grocery.
But thank you a lot.
Please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.
Need help uploading data? click here
Want faster answers? click here
Sure. I hust wasn't aware of how to paste in the data correctly.
Table 1
| Country | Order no |
| United States | 1 |
| Canada | 2 |
| Mexico | 3 |
| Brazil | 4 |
| Argentina | 1 |
| United Kingdom | 2 |
| Germany | 3 |
| France | 4 |
| Italy | 1 |
| Spain | 2 |
| China | 3 |
| Japan | 4 |
| South Korea | 1 |
| India | 2 |
| Australia | 3 |
| New Zealand | 4 |
| South Africa | 1 |
| Egypt | 2 |
| Russia | 3 |
| Saudi Arabia | 4 |
Table 2
| Grocery | Order no |
| Apples | 1 |
| Bananas | 1 |
| Carrots | 1 |
| Potatoes | 1 |
| Tomatoes | 2 |
| Onions | 2 |
| Milk | 2 |
| Eggs | 2 |
| Cheese | 3 |
| Bread | 3 |
| Rice | 3 |
| Pasta | 4 |
| Chicken | 4 |
| Beef | 4 |
| Fish | 4 |
| Butter | 5 |
| Yogurt | 5 |
| Cereal | 5 |
| Flour | 6 |
| Sugar | 6 |
Table 3
| Country | Grocery | Status |
| United States | Apples | On stock |
| Canada | Bananas | Not on stock |
| Mexico | Carrots | Not on stock |
| Brazil | Potatoes | On stock |
| Argentina | Tomatoes | Not on stock |
| United Kingdom | Onions | On stock |
| Germany | Milk | On stock |
| France | Eggs | On stock |
| Italy | Cheese | On stock |
| Spain | Bread | On stock |
| China | Rice | On stock |
| Japan | Pasta | On stock |
| South Korea | Chicken | On stock |
| India | Beef | Not on stock |
| Australia | Fish | Not on stock |
| New Zealand | Butter | Not on stock |
| South Africa | Yogurt | Not on stock |
| Egypt | Cereal | Not on stock |
| Russia | Flour | On stock |
| Saudi Arabia | Sugar | On stock |
Table 4
| Country | Grocery | Status |
| United States | Apples | Not on stock |
| Canada | Bananas | On stock |
| Mexico | Carrots | On stock |
| Brazil | Potatoes | On stock |
| Argentina | Tomatoes | On stock |
| United Kingdom | Onions | On stock |
| Germany | Milk | On stock |
| France | Eggs | Not on stock |
| Italy | Cheese | Not on stock |
| Spain | Bread | Not on stock |
| China | Rice | Not on stock |
| Japan | Pasta | Not on stock |
| South Korea | Chicken | Not on stock |
| India | Beef | On stock |
| Australia | Fish | On stock |
| New Zealand | Butter | On stock |
| South Africa | Yogurt | On stock |
| Egypt | Cereal | On stock |
| Russia | Flour | Not on stock |
| Saudi Arabia | Sugar | Not on stock |
Table 5:
| Country | Grocery | Status |
| United States | Apples | On stock |
| Canada | Bananas | On stock |
| Mexico | Carrots | On stock |
| Brazil | Potatoes | On stock |
| Argentina | Tomatoes | On stock |
| United Kingdom | Onions | On stock |
| Germany | Milk | On stock |
| France | Eggs | On stock |
| Italy | Cheese | On stock |
| Spain | Bread | Not on stock |
| China | Rice | Not on stock |
| Japan | Pasta | Not on stock |
| South Korea | Chicken | Not on stock |
| India | Beef | Not on stock |
| Australia | Fish | Not on stock |
| New Zealand | Butter | Not on stock |
| South Africa | Yogurt | Not on stock |
| Egypt | Cereal | On stock |
| Russia | Flour | Not on stock |
| Saudi Arabia | Sugar | Not on stock |