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 Sure you can downlaod a sample file from here Data.xlxs
Column Date1 to Date5 does contains the dates, If my filter date contains in any of these Date Columns (which is from Date1 to Date5), then I need to show the 'ChosenSeat' it in my table view.
filter date is just a Date Table.
Ahh , got my post unmarked as spam, Autopost spam filteration need imporvement.