Date relation

[koorosh]

Hi Experts, in the model there are two tables but the same as each other. I made a relation between one of them with the Date table but other one has no relation. Two charts were created that seems should be the same, but why do I get different charts?

Regards

https://drive.google.com/file/d/1ny0SMdsuvXnDIOXyZ5u0gOLNXO8195GJ/view?usp=sharing

[v-luwang-msft]

Hi @koorosh ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[amitchandak]

@koorosh , I have checked by converting data type of date to timestamp with format that can show time. Date has a time stamp other than 12 AM, and date table join is failing 

Create a new date in table and join with sales date 

Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw

Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))

in Power Query
DateTime.Date([datetime])