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.
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.
Hi,
It will be the same link that i will share here as well. There is no provision to upload files here.