cancel
Showing results for 
Search instead for 
Did you mean: 
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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.