Conditional Column based on link between another 2 tables

Question

Hello PowerBI Community, I am stuck on a problem and would be very greatful if somebody could assist me.

Table 1 - Customer List

Table 2 - Order

Table 3 - Fruit Prices

Customer List is linked to Orders based on customer ID
Orders linked to fruit prices based on fruit

I am trying to create a conditional column in the customer list table to determine if the orders created could meet a certain criteria. For example

If an order from the customer contains an apple, OR if they have ordered a fruit with price > 2 then TRUE else FALSE

The end result would be an additional column on the customer list table containing true / false values.

Any help would be massively appreciated!

greg_deckler · Answer

Kurt4597&nbsp;This will go a lot faster if you post your data as text so that we can copy and paste it into an Enter data query.

kurt4597 · Answer

Apologies, Here is the file&nbsp;https://easyupload.io/jcpe8c&nbsp;

Forum Discussion