Dynamic date filter using today's date to compute values

[tomekm]

Hello,

I'm trying to create a dynamic date filter that will always take into consideration today's date in order to show only the next/upcoming date for each Item. Please see my table below. The idea is that when I filter on Item = A, and i'm looking at this report today (Nov 11th), it will show me only the row with date = 04-Dec-2021. If I filter on Item = B, it will show blank as all the dates available in the table for this item are in the past. If i filter on Item = C, it will show date = 14-Dec-2021, and so on. 

Any help would be appreciated. Thank you.

Item:	Date:
A	05-Sep-2021
B	04-Jan-2021
C	14-Dec-2021
A	04-Dec-2021
B	19-Feb-2021
C	15-Dec-2021
A	08-Jan-2022
B	20-Mar-2021
C	07-Feb-2022

[smpa01 · Accepted solution]

@tomekm  you can use this measure

Measure = CALCULATE(MAX('Table'[Date]),FILTER(VALUES('Table'[Date]),'Table 1'[Date]>=TODAY()))

[YukiK · Accepted solution]

You can create a calculated column like in the screenshot below. Essentially, creating a column that captures the date if it's upcoming/in the future

Hope this helps! Please give it a thumbs up!

[smpa01 · Accepted solution]

@tomekm  you can use this measure

Measure = CALCULATE(MAX('Table'[Date]),FILTER(VALUES('Table'[Date]),'Table 1'[Date]>=TODAY()))