Power Pivot Data Model: GETPIVOTDATA | #REF! error

[jajatidev]

Hi,
I'm working on a chart view by pulling data from Pivot Tables.

Here is the get data formula I begin with;

=GETPIVOTDATA("[Measures].[Min of RunningTotal]",availability!$A$4,"[availability].[Material]","[availability].[Material].&[ABD6017895]","[Calendar].[Week]","[Calendar].[Week].&[2023-11-06T00:00:00]")

I modified by introducing a cell reference to identify material instead of hard-coaded material number.

=GETPIVOTDATA("[Measures].[Min of RunningTotal]",availability!$A$4,"[availability].[Material]","[availability].[Material].&["&$B$2&"]","[Calendar].[Week]","[Calendar].[Week].&[2023-11-06T00:00:00]")

However, I can't manipulate the week field to make it dynamic. I have tried out the following but no success.

["&TEXT(F3,"MM/DD/YYYY")&"T00:00:00]
["&TEXT(F3,"MM/DD/YYYY""T00:00:00""")&"]

Please advice how to fix it.

Regards,
jajatidev

 

[jajatidev]

Hi,
I was able to identify the issue with the date formate and fixed it.

["&TEXT(F3,"YYYY-MM-DD""T00:00:00""")&"]