Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
nhalloran24
Frequent Visitor

If Statement Multiple Conditions for a calculated column

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

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.