Forum Discussion

Sylvain74's avatar
Sylvain74
Helper III
4 years ago
Solved

Dealing with dates

Hello,   Let's say in my data model I have 1 or more tables with multiple datecode columns (yyyymmdd). I have as well one single dim_time table. Should I add the dim_time table as many time as I h...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi  Sylvain74 ,

     

    Yes,I think creating sereval dim_time tables would make your model look more clean and convenient.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

Sylvain74's avatar
Sylvain74
Helper III
4 years ago

Hello HotChilli,

 

That's clear for me that if I want to filter out the Txn Date and Ship Date separately with slicers, I need to have 2 different relationships.

But for other datecodes in my fact table that I just want to display in user readable format. Should I link each of them to a specific dim_time table to get the correct format or what else?

What should I do? What is the best solution to avoid adding multiple times the dim_time table just for formating purpose?

Thanks.

v-kelly-msft's avatar
v-kelly-msft
Community Support
4 years ago

Hi  Sylvain74 ,

 

Yes,I think creating sereval dim_time tables would make your model look more clean and convenient.

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!