Date relationship needs recreation?

[Testeri]

Hi,

I had a relationship from Table1 to calendar table using date column. Table1 was using long date format and calendar table had short date format. Usually Table1 dates are without time (0:00:00) but if there was other time, connection didn't work and visualizations didn't contain that data.

I changed Table1 date format to short date and connection didn't still work. Connection started to work after I deleted the date relationship between those tables and created it again. I just want to know that:

1.  Is it normal Power Bi feature that date connection doesn't work if data tables are not using same short date format like calendar table?

2. Is it normal that you have to recreate relationships if you change data table date format?

3. Is it somehow possible to fast check if some data are not connected to calendar table correctly?

Thanks.

[amitchandak · Accepted solution]

@Testeri , It is not about format, The table date as time stamp other than 12 AM or 12:00:00

Ast long as they have date/datetime datatype they will join but date should not have timestamp

Create a new date 

new Date = datevalue(Table[Date])

Join this with date table and try.

If change data type to date in power query , it losses timestamp, but that do not happen in DAX

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...