Forum Discussion

maasool's avatar
maasool
Helper I
3 years ago

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!

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

     

    • maasool's avatar
      maasool
      Helper I
      3 years ago

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