Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Two or More date Filters for the same data

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?

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @Anonymous ,

 

Kindly check the attachment whether help.

dateslicer.PNG

 

Best Regards,

Icey

 

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

View solution in original post

5 REPLIES 5
Icey
Community Support
Community Support

Hi @Anonymous ,

 

Kindly check the attachment whether help.

dateslicer.PNG

 

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
Community Support
Community Support

Hi @Anonymous ,

 

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

 

 

Best Regards,

Icey

Anonymous
Not applicable

Hi,

I did not find @amitchandak  acceptable.

I have a table and three slicers

slicer 1=1/1/2000to9/1/2000
slicer 2=1/1/2002to11/1/2002
slicer 3 =9/1/2003to5/1/2004

 Table:

IdCost Date
12731/1/2000
2413/1/2000
3415/1/2000
4487/1/2000
53869/1/2000
6241########
71581/1/2001
8543/1/2001
93495/1/2001
102037/1/2001
111309/1/2001
12355########
13981/1/2002
143103/1/2002
153625/1/2002
162637/1/2002
171599/1/2002
18194########
192201/1/2003
201403/1/2003
21745/1/2003
22937/1/2003
231449/1/2003
24211########
253961/1/2004
262403/1/2004
272815/1/2004

 

The results should be in the detail report:

IdCost Date
12731/1/2000
2413/1/2000
3415/1/2000
4487/1/2000
53869/1/2000
13981/1/2002
143103/1/2002
153625/1/2002
162637/1/2002
171599/1/2002
1819411/1/2002
231449/1/2003
2421111/1/2003
253961/1/2004
262403/1/2004
272815/1/2004
Anonymous
Not applicable

Any suggestion on how this can be achieved?

amitchandak
Super User
Super User

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.