I have an interesting one here. I'm looking to try and substitute the text from a cell into the measures portion of a CubeValue formula in Excel. The CubeValue references data from a related sheet in PowerPivot and I'm bringing over multiple columns of numbers so it would make life easier if I could substitute a column name for the text in the "Sum of..." portion on the CubeValue Formula.
Current Formula
=CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of PROJ JAN 19]",etc.
I'm trying to substitute a Cell Reference for the text of PROJ JAN 19 in the measures portion of the formula but haven't found a solution anywhere. The literal result would be something like this: =CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of AA2]" where AA2 is a cell that has this text in it: PROJ JAN 19
There are multiple months to bring in so there are additional columns with PROJ FEB 19, PROJ MAR 19, PROJ APR 19, etc.
thank you !
Current Formula
=CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of PROJ JAN 19]",etc.
I'm trying to substitute a Cell Reference for the text of PROJ JAN 19 in the measures portion of the formula but haven't found a solution anywhere. The literal result would be something like this: =CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of AA2]" where AA2 is a cell that has this text in it: PROJ JAN 19
There are multiple months to bring in so there are additional columns with PROJ FEB 19, PROJ MAR 19, PROJ APR 19, etc.
thank you !