Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
maasool
Helper I
Helper I

GETPIVOTDATA referencing error

Hello

My cube formula looks like this:

=GETPIVOTDATA("[Measures].[Sum of Value 3]";$A$18;"[Kalender].[YYYYMM]";"[Kalender].[YYYYMM].&[2.02001E5]")

I'd like to change this highlighted part to a reference to a cell. However, If I do it like this, then I get REF error. What is the problem?

=GETPIVOTDATA("[Measures].[Sum of Value 3]";$A$18;"[Kalender].[YYYYMM]";"[Kalender].[YYYYMM].&["&C19&"]")

In cell C19 I have the YYYYMM value used in the pivot (202001).

Thanks for the help!

2 REPLIES 2
Anonymous
Not applicable

Hi @maasool ,

 

I'm sorry you're having trouble. But your question doesn't seem to belong to the Power Query forum. In the Power Query, M language is used mostly. The function you provided seems to be from the Excel, right?

You may refer to the document for reference:

GETPIVOTDATA function (microsoft.com)

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Microsoft doesn't seem to have Power Pivot forum and this seemed the closest place to it.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors