Forum Discussion
Date Filter
I was having trouble with the date filter. For example, if i select this date range, I want all the data that is between 01/01/2019 and 01/01/2021 but not including the values on 01/01/2021.
However, the issue with this filter is that it includes the values on 01/01/2021.
I was wondering if anyone had the same issue or if there was anything I could do to fix this
Hi,
the only solution i can find is this:
To achieve it you have to create another column in your calendar
Date+1 = Date_Dim[Date]+1then use 2 slicerone on date with after Datethe other on before with Before Date +1
If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
3 Replies
Hi,
probably you have to select 31/12/2020 and not 01/01/2021
If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
Hi,
the only solution i can find is this:
To achieve it you have to create another column in your calendar
Date+1 = Date_Dim[Date]+1then use 2 slicerone on date with after Datethe other on before with Before Date +1
If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !