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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Uno707
Frequent Visitor

How to search if value 1 is with in a date range based on multiple other values?

I'm really struggeling to figure out where to begin on a task I'm trying to solve.

 

Columns in current data set I've been attempting to work with;

Item | Item ID | Location | Date 

 

the problem statement:

"If Item is in Location A, and Location B, and the Date in Location A is less than any Date listed for Location B return True"

variables:

Each item can have mutliple dates

In plane text - If an Item in one location is expiring before the same item in another location flag this item.

 

Example: 

ItemItem ID Location DateT/F
AA-123 North1/1/23F
AA-1234 South1/15/23T
AA-12345North1/31/23F
AA-12346South2/15/23F

 

 

Any ideas on how to search the range and return above results?

 

0 REPLIES 0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.