Forum Discussion
Date relation
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
2 Replies
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])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
