Filter between dates

[walker21]

Is it possible to filter a page between two different dates? I need my page to show data that is in the last 31-60 days. The slicer and relative date filter does not allow me to enter an inbetween time without using specific dates.

[v-zhangti · Accepted solution]

Hi, @walker21 

For example, I want to filter data for the last 3-6 days.

Hope this method helps you.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[walker21]

@themistoklis 

I am receiving this error when using the above formula. Am I missing something?

[themistoklis]

@walker21 

I didnt get any errors when i tried the same formula.

How are you creating the table?

Do you go to Home Tab --> Modelling --> New Table

[walker21]

@themistoklis yes. Home - modeling - New Table.

Then I receive the error saying I have too few arguments for some reason.

[themistoklis]

@walker21 

Maybe you can create a custom date slicer.

See linke below:

https://www.youtube.com/watch?v=fKygF7VEJnQ

In your case you can use the following formula

ADDCOLUMNS(
DATESBETWEEN('Date'[Date], TODAY()-60, TODAY()-30),
"Selection", "30-60"
)