Forum Discussion
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.
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
3 Replies
- MariuszCommunity Champion
- MariuszCommunity Champion
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