Forum Discussion
Helper IIIWorking 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!
Helper IIIHi, 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.
Community SupportHi 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.