cancel
Showing results for
Did you mean:
Helper I

## Dynamic date filter using today's date to compute values

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
2 ACCEPTED SOLUTIONS
Super User

@tomekm  you can use this measure

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

Proud to be a Super User!

New Animated Dashboard: Sales Calendar

Responsive Resident

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!

2 REPLIES 2
Responsive Resident

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!

Super User

@tomekm  you can use this measure

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

Proud to be a Super User!

New Animated Dashboard: Sales Calendar

Announcements