Forum Discussion
rajulshah
6 years agoResident Rockstar
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...
- 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
rajulshah
6 years agoResident 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?
Mariusz
6 years agoCommunity 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
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.