Forum Discussion
Filter table rows by Date Table , where Main Table contains dates in 5 columns and can be duplicate
Hi users, I need to filter my table as per selected date or date range from Date table column (refer left side of the image) and I need to filter weather the range of those dates contains in my ...
Hi Anonymous,
I'd like to suggest you create a duplicate table and apply unpivot columns on the copied table, you can link this new table with raw tables and it does not affect the raw table relationships.
Regards,
Xiaoxin Sheng
amitchandak
Super User
Super UserAnonymous ,Can you share sample data and sample output in table format?
amitchandak Apologies my shared excel link has been removed by Moderator.
Here a sample data how its looks like, This is my main table which I need to filter it out by date range (Slicer having Date Table).
and the column ( Date1 to Date5 ) should filter out when I select any date range which lies in any of these 5 columns.
Hope this make sense.
ChosenSeatDate1Date2Date3Date4Date5
| Seat 6 | 12-07-2020 00:00 | 13-07-2020 00:00 | |||
| Seat 10 | 29-07-2020 00:00 | ||||
| Seat 106 | 02-07-2020 00:00 | 03-07-2020 00:00 | 04-07-2020 00:00 | 05-07-2020 00:00 | |
| Seat 109 | 31-07-2020 00:00 | 01-08-2020 00:00 | 02-08-2020 00:00 | 03-08-2020 00:00 | |
| Seat 13 | 02-07-2020 00:00 | 03-07-2020 00:00 | 04-07-2020 00:00 | ||
| Seat 13 | 06-07-2020 00:00 | 07-07-2020 00:00 | |||
| Seat 15 | 04-07-2020 00:00 | 05-07-2020 00:00 | 06-07-2020 00:00 | 07-07-2020 00:00 | |
| Seat 17 | 02-07-2020 00:00 | ||||
| Seat 17 | 29-07-2020 00:00 | ||||
| Seat 19 | 29-07-2020 00:00 | ||||
| Seat 19 | 04-08-2020 00:00 | ||||
| Seat 21 | 02-07-2020 00:00 | 03-07-2020 00:00 | |||
| Seat 23 | 03-07-2020 00:00 | 04-07-2020 00:00 | 05-07-2020 00:00 | ||
| Seat 27 | 03-07-2020 00:00 | 04-07-2020 00:00 | 05-07-2020 00:00 |