date and time column

[powerbiexpert22]

i have date column in fact table which has datetime data type and date column in calendar table has also datetime data type (dd-mm-yyyy 12:00:00) 

when i join fact table and calendar table based on date column then the join is not working properly

i changed the data type of fact table from datetime to date and it is working fine. is there any other way to do it?

[v-kaiyue-msft]

Hi @powerbiexpert22 ,

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mickey64]

Normally, when I create a calendar table, I use the 'CALENDARAUTO()' function.
What function did you use to create a calendar table with the time being 12 o'clock?
I think the problem is that the time in the calendar table data was 12 o'clock, not midnight.

[bhanu_gautam · Accepted solution]

@powerbiexpert22 , I think you approach is correct to extract date from date and time and you can do it either in Power query or at front end using DAX