Forum Discussion
Working with two datasets
Hi cocoloco79,
Hi ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.If our response addressed by the community member for your query, please mark it as Accept Answer and give us Kudos. Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
Hi cocoloco79,
We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .
If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.
Hi, I created a combined table, inculding the many to many relationship.
Many to many relationship is causedn as the calendar is exeeding todays date, I believe.
Is there a function to increase the dates as the dataset grows?
Anyways, even with the many to many relationsp, the table works correctly now.
Hi cocoloco79,
Hi ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.If our response addressed by the community member for your query, please mark it as Accept Answer and give us Kudos. Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!Hi cocoloco79,
Thank you for the additional details and clarification.
You're correct in identifying that the many-to-many relationship may be caused by the calendar table extending beyond the actual range of dates used in your dataset. When the calendar includes dates not present in related tables, it can sometimes result in unintended relationships or ambiguous joins.
To address your question-- yes, it is possible to make the date range dynamic so that it automatically grows or adjusts based on the data. This is commonly done by creating the date table using the actual minimum and maximum dates found across your source tables. Doing so ensures that the calendar only includes dates relevant to your data, which can help reduce the risk of many-to-many relationships and improve model performance.
In Power BI, this can be achieved using Power Query or DAX. If you prefer not to use DAX, Power Query offers the ability to reference the date range from your fact tables and generate a calendar accordingly during data load.
Happy to help! If this addressed your concern, marking it as "Accepted Solution" and giving us "kudos" would be valuable for others in the community.
Thank you.
Hi cocoloco79,
I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.
If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you..
Hi cocoloco79,
Accepting a helpful reply can assist other users in the community by addressing similar issues. Thank you for your support, and have a great day.
We encourage you to continue using the Microsoft Fabric Community Forum.