Date Filter

[Anonymous]

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

[Anonymous]

I was wondering if you knew of a way for me to still select 01/01/2021 but not include the data values for 01/01/2021. Like if there were measures I would have to make or something. 

[serpiva64 · Accepted 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]+1

then use 2 slicer 

one on date with after Date

the 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 !

[serpiva64]

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 !