DAX works in Power BI, but not Analysis Services

[Anonymous]

Anyone know why 'Table'[Column].[Year] returns the year number in Power BI, but when I paste into Analysis Services is does not work?  And when I search online I just see the Year function wrapping the Table and column...      

like so... Year('Table'[Column])

[HotChilli · Accepted solution]

This is when Table[Column] is a date.

In Power Bi, a date has a hidden date dimension  and you have access to the columns in that table (.[Year], .[Month], .[Quarter] etc)

Analysis Services doesn't have that.