Problems with having 2 date dimensions?

[Anonymous]

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?

[v-angzheng-msft · Accepted solution]

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.

[amitchandak]

@Anonymous , You can mark the new date table also as date table.

The new dimension is only needed if you want filter dates on different duration. Else inactive join and userelationship can help

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970