GetPivotData Erorr Pivot Table Power BI Dataset

[wsnyder]

Hi all,

I connected to a Dataset in Power BI and built a Pivot Table in Excel.
I am trying to create a GetPivotData formula to summarize the Pivot Table, but I'm doing something wrong when I try to update the formula with cell references.

=GETPIVOTDATA("[Measures].[Revenue New]",Pivot!$A$5,"[Date Table].[Quarter]","[Date Table].[Quarter].&[Q1]","[Date Table].[Year]","[Date Table].[Year].&[2019]","[Bookings].[Team]","[Bookings].[Team].&[West]")

Here is what I have so far after I update cell references for Quarter, Year & Team:

=GETPIVOTDATA("[Measures].[Revenue New]",Pivot!$A$5,"[Date Table].[Quarter]","[Date Table].[Quarter]."&C$3&","[Date Table].[Year]","[Date Table].[Year]."&C$2&","[Bookings].[Team]","[Bookings].[Team]."&$A4&")

Any thoughts what I am doing wrong?
Thanks
-w

 

[wsnyder]

I seem to be a bit closer with this version, but now getting a #REF! error:

=GETPIVOTDATA("[Measures].[Revenue New]",Pivot!$A$5,"[Date Table].[Quarter]","[Date Table].[Quarter].[" & C$3 & "]","[Date Table].[Year]","[Date Table].[Year].[" & C$2 & "]","[Bookings].[Team]","[Bookings].[Team].[" & $A4 & "]")

Thanks,
-w

 

[wsnyder]

Got it. This appears to be working:

=GETPIVOTDATA("[Measures].[Revenue New]",Pivot!$A$5,"[Date Table].[Quarter]","[Date Table].[Quarter].&[" & C$3 & "]","[Date Table].[Year]","[Date Table].[Year].&[" & C$2 & "]","[Bookings].[Team]","[Bookings].[Team].&[" & $A4 & "]")