Two or More date Filters for the same data

[Anonymous]

I have Data from a View and I want to filter the data with three date ranges. Not necessarily the same date previous year etc. For the same field "Status Date".

Eg: 

Filter1 Date Range: 01-01-2005 to 01-01-2006

Filter2 Date Range: 06-06-2009 to 01-01-2010

Filter3 Date Range: 09-19-20013 to 06-22-2015

For the same date field in the view. How do i do it?

[Icey · Accepted solution]

Hi @Anonymous ,

Kindly check the attachment whether help.

Best Regards,

Icey

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

[Icey]

Hi @Anonymous ,

Please let us know if the post @amitchandak provided is helpful.

Best Regards,

Icey

[Anonymous]

Hi,

I did not find @amitchandak  acceptable.

I have a table and three slicers

slicer 1=	1/1/2000	to	9/1/2000
slicer 2=	1/1/2002	to	11/1/2002
slicer 3 =	9/1/2003	to	5/1/2004

 Table:

Id	Cost	Date
1	273	1/1/2000
2	41	3/1/2000
3	41	5/1/2000
4	48	7/1/2000
5	386	9/1/2000
6	241	########
7	158	1/1/2001
8	54	3/1/2001
9	349	5/1/2001
10	203	7/1/2001
11	130	9/1/2001
12	355	########
13	98	1/1/2002
14	310	3/1/2002
15	362	5/1/2002
16	263	7/1/2002
17	159	9/1/2002
18	194	########
19	220	1/1/2003
20	140	3/1/2003
21	74	5/1/2003
22	93	7/1/2003
23	144	9/1/2003
24	211	########
25	396	1/1/2004
26	240	3/1/2004
27	281	5/1/2004

The results should be in the detail report:

Id	Cost	Date
1	273	1/1/2000
2	41	3/1/2000
3	41	5/1/2000
4	48	7/1/2000
5	386	9/1/2000
13	98	1/1/2002
14	310	3/1/2002
15	362	5/1/2002
16	263	7/1/2002
17	159	9/1/2002
18	194	11/1/2002
23	144	9/1/2003
24	211	11/1/2003
25	396	1/1/2004
26	240	3/1/2004
27	281	5/1/2004

[Anonymous]

Any suggestion on how this can be achieved?

[amitchandak]

@Anonymous , refer if this can help

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601