Forum Discussion
How .[Date] works
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.
Hi HugoDataAve2023 ，
In Power BI, the property allows you to extract just the date part of a datetime type. This is particularly useful when you need to perform date-based calculations without the time component. This attribute returns all the dates in the year in which the date falls.
For your case with the function, it's odd that it didn't return the expected result. Here's what you can try to troublershoot this:
You can format the visual to only display the date part or create a calculated column to extract the date:
Best regards
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly