Forum Discussion

HugoDataAve2023's avatar
HugoDataAve2023
Frequent Visitor
2 years ago
Solved

How .[Date] works

Some time ago I made a formula with date, but my column was type datetime. When I typed, Power BI suggested me to include .[Date], just after the colunm name, like this 'Table'[column].[Date]. When I...
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    HugoDataAve2023 When you have Auto Time Intelligence turned on in your Options, Power BI creates a hidden Date table in your model that is linked to the Date column. One table is created per Date column. The .[Date] syntax simply references this hidden Date table which provides a hierarchy of different values like Year, Month, Day, etc. 

     

    Using Auto Time Intelligence is generally not recommended as it bloats your semantic model.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

HugoDataAve2023 When you have Auto Time Intelligence turned on in your Options, Power BI creates a hidden Date table in your model that is linked to the Date column. One table is created per Date column. The .[Date] syntax simply references this hidden Date table which provides a hierarchy of different values like Year, Month, Day, etc. 

 

Using Auto Time Intelligence is generally not recommended as it bloats your semantic model.