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 Joinin...
Need Help
Show and Tell
Mariusz's avatar
Mariusz
Community Champion
6 years ago

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
6 years ago

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?

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi rajulshah 

     

    The other approach is to use Measures and activate the relationship via USERELATIONSHIP,

     

    Or use date columns stored in the tables and Auto date/time future.
    https://docs.microsoft.com/en-gb/power-bi/desktop-auto-date-time 

    .

     

    Best Regards,
    Mariusz

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

    Please feel free to connect with me.
    LinkedIn