Forum Discussion
Power BI relationships
Hi There, I'm having issues with a relationship, I though it would be a simple enough model, but when I add the date from the Transaction table, I get the error attached. Any ideas?
1 Reply
- foodd
Community Champion
An observation is that it appears that the model is missing a dedicated and related dates table to support time intelligence. If this is missing, please add one in addition to the feedback below.
Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
