Forum Discussion
dot in date
Whenever I write a query involving some sort of date table data, I get 'Date'[Date].SOMETHING. I do know what 'Date'[Date] is, but what exactly is that DOT stuff? What does it signify? How is 'Date'[...
The Dot indiciates how you want to format or extract from that data.
So 'Table'[Field].Date would get you the Date value out of the field (which might have a Date and Time value).
'Table'[Field].Day would get you the Day value out of a field (which might have a Date or Date and Time).