Forum Discussion
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?
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.
5 Replies
Anonymous , refer if this can help
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
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
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.
