Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    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's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

You may refer to my solution at this link.

 

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
8 years ago
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.
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    It will be the same link that i will share here as well.  There is no provision to upload files here.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        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.