Forum Discussion

PanosSia's avatar
PanosSia
Regular Visitor
3 years ago

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

  • 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.

  • Hi,

    Doesn't that simply translate into "Return the farthest date for each ID"?