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.
Hello
Thank you I have managed to download the pbix file now. Please can you walk through what you have done. I am a little confused where the a custom column has been created.
Many thanks
Jo
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.