Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
sample file https://easyupload.io/jcpe8c
@Kurt4597 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.
User | Count |
---|---|
77 | |
76 | |
42 | |
30 | |
24 |
User | Count |
---|---|
97 | |
91 | |
52 | |
47 | |
46 |