Forum Discussion

Balakrishann's avatar
Balakrishann
New Member
10 years ago

Custom Visual Filter- Between option for date field

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

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    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's avatar
    Anonymous
    Not applicable
    10 years ago

    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