This question relates, in part, to this thread

https://www.excelforum.com/excel-cha...ml#post5557282

I have a pivot table built from a Data Model. When I try to do some calculations based on the data in the table and click on a cell in the table it returns a structured reference to the table. Which is fine. I get something like this;

=GETPIVOTDATA("[Measures].[Count of LTC]",$B$4,"[DataModelTable].[UPDATE_DATETIME]","[DataModelTable].[UPDATE_DATETIME].&[2021-04-27T00:00:00]")

I can understand this and relate the table references back to my Data Model. I don't understand what the &[2021-04-27T00:00:00] actually means. It is an explicit reference to a value in the table and I guess it is as simple as that. I just want to understand this a little better so I can progress my other issue.

Thanks