Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Item | Item ID | Location | Date | T/F |
A | A-123 | North | 1/1/23 | F |
A | A-1234 | South | 1/15/23 | T |
A | A-12345 | North | 1/31/23 | F |
A | A-12346 | South | 2/15/23 | F |
Any ideas on how to search the range and return above results?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |