The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Looking for data to be shown with certain perameters being met for each row for a True or False flag to be shown but having difficutly with coming up with the code for for the formula.
Within my table there is a column for Location Number, Exit Number, quantity of items, seconds (timeframe), and product ID's.
Below is a breakdown of what needs to be shown:
True to be shown IF:
items greater than a quantity of 50 within a second count time frame within a same location number and exit door within the location containing multiple (unique product ID's)
False if less than 50 items
Yeah... It would be good to understand that we DO NOT SEE your model and have no idea about it. So, it would be good if you could put the following:
@nhalloran24 wrote:
True to be shown IF:
items greater than a quantity of 50 within a second count time frame within a same location number and exit door within the location containing multiple (unique product ID's)
False if less than 50 items
in a human understandable and unambiguous English. Then maybe someone could help you.
Thanks.
Best
Darek
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
34 | |
15 | |
12 | |
7 | |
6 |