Forum Discussion
Date Table Showing Incorrect Month Number
MFelix thank you for your time and assitance.
What is the active relationship you have between the calendar and the BD?
So the active relationship, I have between the 8D and the calendar is via my fact table. 8D[key] 1 --> * Fact Table[key] -- >Calendar
However, I have an inactive relationship between my 8D table and my calendar table
8Ds[8D Resolve Date Rel] (This column is a duplicate of the Resolved Date) --> Calendar[date]
Ill keep working on this with your provided suggestions and report back with what happens. Im kind of convinced I have made a spiderweb of relationships between my tables that I am struggling to correct.
Hi MiguelSantos ,
If you want can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.