Forum Discussion
Filtering on 2 date fields in a table
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.
Hi
that's great thanks and helps sum up the number of created inspections. What i need to do is show a list of created inspections and a list of closed inspections on the same report page using the same filters - similar to this. At the moment both reports show the same inspections just with the created date or completed date Any ideas? Thanks for your help.
hi Anonymous,
Are these your expected results?
yes Ashish_Mathur! I would be very grateful if you could share how you have done this.
Many thanks
Jo.
- Hello Thank you for your help. I have downloaded your example but unfortunately cannot open the file. Please can you post the example pbix file please? Kind regards Jo.