Filter report by multiple date fields in as single shared dataset

[rajulshah]

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.

[Mariusz]

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]

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 · Accepted solution]

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