Forum Discussion
Filter rows based on dynamic data range (slicer) and conditions
I have table[id], table[category], table[date]
for each id it can have many possible categories values a,b,c, d,
ID CATEGORY DATE
1 'a' 1/15/2021
1 'b' 1/02/2021
2 'a' 3/04/2022
3. 'c' 5/07/2023
i want to filter these rows with date range with table[date] but with the twist that when for each id
if category = 'a' and category = 'b' to keep only the latest of the 2 between the range of of the dynamic date slicer (table[date])
2 Replies
- lbendlin
Super User
Your sample data seems not to cover your scenario. Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided. - Ashish_Mathur
Super User
Hi,
Doesn't that simply translate into "Return the farthest date for each ID"?