Forum Discussion
Filtering on 2 date fields in a table
Hi I'm trying to write a report that contains 2 table with one slicer that filters on financial year and month. The first table will contain a list of all the inspections created within the mont...
Hi,
It will take a lot of time for me to walk you through all that i have done. To answer your specific question, the Custom column i created has converted two date columns into a single one by exploding each data of the date range into a single row. This has been done so that we can relate this single column to the Date column of the Calendar Table.
Please feel free to ask any specific questions that you may have.
Ashish_Mathur apologies for the delay in replying to your message. I have looked at your solution in detail and thank you for responding to my question. I have applied your method to my data and all has worked. Thanks again for taking the time to answer my question.
Kind regards
Jo
You are welcome.