datetime column

[powerbiexpert22]

considering the data modeling best practices , we should split single datetime column in data model to 2 columns (date and time) for reducing the data model size

i have datetime columns available in 4 tables out of 7 in data model

do i need to split datetime column available in all 4 tables or only in calendar table?

do i need to split in case if time component of datetime column remains same (example 12:00:00:00)? 

[audreygerred · Accepted solution]

Hi! Ideally, you will have a star schema and have a date table where each row represents a date and a separate time table where each row would be a record of time in the granularity you choose (hours, minutes, seconds). Then, your fact tables that have date and time you would separate date and time into two fields and connect date from dim to date in fact and time from dim to time in fact.