Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
2 years ago
Solved

datetime column

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...
Need Help
  • audreygerred's avatar
    audreygerred
    2 years ago

    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.

audreygerred's avatar
audreygerred
Super User
2 years ago

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.