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...
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.

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
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.