Filter future dates only

[maneschr2022]

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 · Accepted solution]

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]

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]

Hi @maneschr2022 

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

[tamerj1]

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"