Forum Discussion

maneschr2022's avatar
maneschr2022
Helper II
4 years ago
Solved

Filter future dates only

Hi,  I want to create a table visual, and for this table, I would like to filter the values using a DAX formula on the Date column, to show dynamically values that are related to future dates (from ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi maneschr2022 ,

     

    I think you can filter your visual by "Relative date" filter type in [Date] column.

    For example, I have a sample with data from 6/1/2022 to 7/30/2022. Now I want to show data in N days/weeks... and so on after today. We can use Relative date filter type to filter data in future.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi maneschr2022 
You can try
Filter Measure =

COUNTROWS ( FILTER ( TableName, TableName[Date] >= TODAY ( ) ) )

 

Place it in the filter pane of the visual, chose "is not blank"and select "Apply filter"