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...
Need Help
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.