May 25 2021 11:37 AM
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
May 25 2021 01:38 PM
SolutionI'd use
=CUBEVALUE("ThisWorkbookDataModel","[OviCamCsts_tabela].[rubrica].[" & G12 & "]","[Measures].[Sum of IVA]")
Please check attached.
May 26 2021 10:05 AM
May 26 2021 01:15 PM
@Miguel_Rolo , you are welcome.
Just in case Tips & Tricks for Writing CUBEVALUE Formulas - Excel Campus
May 28 2021 11:58 PM - edited May 29 2021 12:06 AM
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
May 29 2021 06:37 AM
Yes, cube functions are working with text parameters. If you combine the text properly any function shall work with it.
May 25 2021 01:38 PM
SolutionI'd use
=CUBEVALUE("ThisWorkbookDataModel","[OviCamCsts_tabela].[rubrica].[" & G12 & "]","[Measures].[Sum of IVA]")
Please check attached.