Custom Visual Filter- Between option for date field

[Balakrishann]

Hi,

  I need to filter the date field with "between" function, i couldn't find the option for this .Can someone please help?

Regards,

Balakrishnan

[Anonymous]

Hi @Balakrishann,

   if you want to use a function like "between" in DAX there is DATESBETWEEN() that allows you to create a view of your datas.

Here a schema of what to do:

But I think that the solution provided by @Anonymous is better.

[Anonymous]

Hello @Balakrishann

You can do this on the visual filter, when you use date field.

You open the visual filter and swith from "basic filter"  to "Advanced filter":

When you're in the advanced filter option you can choose the lower and upper boundaries :

 

 After that, you apply and it should work.

Let me know if that's you're wanted (or not 🙂 ).

Sébastien