GetPivotData relative referencing

[Miguel_Rolo]

Hello

I'm trying to change from absolute to relative referencing with GetPivotData.

I'm not an Excel advanced user but tried to get help in several forums and did not succeed getting an answer.

I'm attaching an example

PC/Windows 10; Office 365;

Power Pivot model using Power Query to import data

(sorry if this is not the right place to post)

Thanks

[#2 · Accepted solution]

@Miguel_Rolo 

I'd use

=CUBEVALUE("ThisWorkbookDataModel","[OviCamCsts_tabela].[rubrica].[" & G12 & "]","[Measures].[Sum of IVA]")

Please check attached.

[#3]

@Sergei Baklan 

Great

It works, problem solved (I need to study cube functions  . . .)

Thanks again

[#4]

@Miguel_Rolo , you are welcome.

Just in case Tips & Tricks for Writing CUBEVALUE Formulas - Excel Campus

[#5]

@Sergei Baklan 

Thank you for the link, very useful.

When starting using the cubefunctions I tried to use GetPivotData using in the cell reference the syntax like in your example [" & A1 &"] and it works!

I hope it is possible to understand what I mean

(sorry for my late reply)

Thanks

[#6]

@Miguel_Rolo 

Yes, cube functions are working with text parameters. If you combine the text properly any function shall work with it.