Making relationship between 2 date columns breaks one of them

[sandra_p]

I have a table Date with column Date - where all dates are listed.

Then I have a table with worklogs - each worklog has date, for which it is done.

When I make a relationship between these 2 tables using these date/time columns, the date field in worklogs table breaks and is not recognized as date/time field in existing DAX expressions.

Attached images, how it looks like after the relationship has been made. Interesting detail is, that this happens even, if the relationship  is not active.

[amitchandak]

@sandra_p , this does not have time. The relation with the date table should work.

Or you need have the only date column

Date 1 = Table[Date time].date

Join it with date calendar

[sandra_p · Accepted solution]

Thank you for answer!

In both tables column was formatted as Date/time (time doesn't appear, because in the source, worklogs don't have time, just date). While I didn't made a relationship, everything was ok.

The solution, was simply remove in DAX statements .[Date] part for worklog date. Then everything is ok.

Not sure, why relationship broke it, but removing .[Date] (which was ok, while there was no relationship) after making a relationship, solved the problem.