GETPIVOTDATA referencing error

[maasool]

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!

[Anonymous]

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]

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