Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Problems with having 2 date dimensions?

I have a basic model with a fact table, and 2 dimensions (one of them is Date dimension).

 

 

Now, a new column with a date has been added to the fact table… Therefore I have created a second ‘Dim Date’ and connected to it:

 

 

 

 

I have the next doubts:

 

Can I have any problem in my .pbix or cube if I use 2 dim dates?

 

Shall I mark this new ‘dim date’ also as ‘Mark as date table’? can I have 2 tables marked as date table?

 

 

 

 

 

This new dim date shall be used only as a filter in the pbix I shouldn’t be using  any time intelligence on it?

Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Anonymous 

    According to my research, you can mark multiple tables as date tables.

    After you mark a table as a date table, you are not able to continue using automatic time intelligence.
    The Auto date/time is a data load option in Power BI Desktop. The purpose of this option is to support convenient time intelligence reporting based on date columns loaded into a model. 

    You can read the following document for more information.

    https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time



    Best Regards,
    Community Support Team _ Zeon Zheng


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

2 Replies