Forum Discussion
fschiro
6 years agoFrequent Visitor
What does the dot command do [column].[column]
What does the dot "." command do in Dax? In a quick measure I noticed 'DimDate'[Date].[Date] I went to find documentation as to what was the purpose of the .[Date] in the [Date].[Date], but I c...
- 6 years ago
Hi fschiro
Its a DAX reference to auto date hierarchy table that you can not see it in your model as it's hidden, normally you would use it if you do not have a date dimension.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
jdbuchanan71
6 years agoSuper User
In Power BI the auto date/time setting automatically creates one date table for each date column in the model.
Columns in these auto-created tables can be accessed through “column variations”.
'Sales'[Order Date].[Date]