Date Relationship not working

[gabilamarcks]

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 having columns Date and its associated FiscalYear. A relationship was created between the 2.

However, when I go to my visuals, all the engagements are getting a FiscalYear value as blank.

Can you pls help me?

[Seth_C_Bauer]

@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?

[sjenkinsdc]

Thank you for this a year and some months later! I had the data type correct in the model but not the query.  

[gabilamarcks]

Indeed the data types were different when I went to "Edit Queries". I adjusted both for Date/Time in the queries and the models. Still doesnt work. I am sure there are matching data values in both tables.

[Seth_C_Bauer]

@gabilamarcks did you "Close and Apply" the change?

[gabilamarcks · Accepted solution]

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.

[aoberlander]

If you double click on the relationship line what does it look like?

That will help in getting a better understanding of the issue.

[gabilamarcks]

There we go

[Anonymous]

Almost certainly the problem is your CreatedDate also has a time.  Even if not "displayed" that way.  You need to strip those off.