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.
Super UserPlease 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 My datamodel looks like this:
I have tried various ways of relatioships, but it does not show the desired output.