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

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()))