Forum Discussion

tomekm's avatar
tomekm
Helper III
4 years ago
Solved

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:
A05-Sep-2021
B04-Jan-2021
C14-Dec-2021
A04-Dec-2021
B19-Feb-2021
C15-Dec-2021
A08-Jan-2022
B20-Mar-2021
C07-Feb-2022
Need Help
  • smpa01's avatar
    smpa01
    4 years ago

    tomekm  you can use this measure

    Measure = CALCULATE(MAX('Table'[Date]),FILTER(VALUES('Table'[Date]),'Table 1'[Date]>=TODAY()))
  • YukiK's avatar
    YukiK
    4 years ago

    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

  • smpa01's avatar
    smpa01
    Community Champion
    4 years ago

    tomekm  you can use this measure

    Measure = CALCULATE(MAX('Table'[Date]),FILTER(VALUES('Table'[Date]),'Table 1'[Date]>=TODAY()))
  • YukiK's avatar
    YukiK
    Impactful Individual
    4 years ago

    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!