Forum Discussion
Solved
Date Relationship not working
Hi all, I have a table wich contains all the engagements and associated Create Date. I want to create visuals that show engagements grouped by FiscalYear. To do that I created another table havin...
Yes did. I got a solution for it. It was a problem of not matching data type. But I had to create a calculated column having data type as "Date" from the original "Data/Time" column, for some reason I was getting an error in all rows just chaging the data type in the original column, so this extra column was needed. After creating this new column I updated the relantioship between the two and it works now. Thanks much.
gabilamarcks Check the datatypes in both the "Edit Queries" section as well as the model. Make sure they match. If that doesn't work, does the date value exist in both tables?
Thank you for this a year and some months later! I had the data type correct in the model but not the query.