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 after today`s date)

Does anyone know which DAX formula could help to achieve this?

 

Thanks in advance!

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

4 Replies

  • 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"

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.

  • maneschr2022's avatar
    maneschr2022
    Helper II
    4 years ago

    Hi tamerj1 , thanks for your reply!, it works fine, the only thing I need to change is the expression of COUNTROWS, as I want to display the dates instead of counting them. Which would work for this case?

    Thank you!