topic Re: Filter future dates only in DAX Commands and Tips

Filter future dates only

maneschr2022 — Tue, 14 Jun 2022 07:04:54 GMT

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!

Re: Filter future dates only

tamerj1 — Tue, 14 Jun 2022 08:30:45 GMT

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"

Re: Filter future dates only

maneschr2022 — Wed, 15 Jun 2022 01:38:08 GMT

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!

Re: Filter future dates only

tamerj1 — Wed, 15 Jun 2022 03:18:26 GMT

Hi maneschr2022

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

Re: Filter future dates only

Anonymous — Fri, 17 Jun 2022 08:44:50 GMT

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.