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.

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!

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi maneschr2022 

would you please share a screenshot of the results you are getting?