Forum Discussion

rajulshah's avatar
rajulshah
Resident Rockstar
6 years ago
Solved

Filter report by multiple date fields in as single shared dataset

Hello,

 

Below is my data structure:


This is my sample dataset structure. I am using a single shared dataset across multiple reports. 
By default, the reports should be filtered by JoiningDate, but few of the reports should be filtered by PaidDate. Note that this is just a part of the dataset structure; I can't be directly using the date fields from the fact tables.

How do I handle such scenario?
Please note that I don't want to handle it using measures as the report would have raw data and the whole report should be filtered.

 

Any help would be great.

Thanks in advance.

 

3 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion

    Hi rajulshah 

     

    If you don't want to activate your relationship via USERELATIONSHIP then your other option is to duplicate your date dimension.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn


     

    • rajulshah's avatar
      rajulshah
      Resident Rockstar

      Thank you for the response Mariusz!

      But I have multiple tables with such multiple Date columns. If I would follow this approach, I guess I will then start adding date tables according to the date fields.

      Any other approach do you have?