Forum Discussion

Edouardbrasier's avatar
Edouardbrasier
Copper Contributor
Nov 02, 2022

hash # doesn't work with CubeValue formula

Hello,

I have tired to use CubeValue with # and couldn't make it work. 

I have tried both CubeValue syntaxes, no luck. Has anyone managed to use it with #?

For the same power pivot data I was able to use # with with getpivotdata but I want to use CubeValue.

 

Thanks

Formulas and Functions
  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Nov 03, 2022

    Hi Edouardbrasier 

     

    could you provide more information on how you intend to use CUBEVALUE with # in your environment? Usually, with Cube function you dig directly into the datamodel and I cannot think of how # would help here.

     

    • Edouardbrasier's avatar
      Edouardbrasier
      Copper Contributor
      Nov 03, 2022
      you can quickly create a test environment with OLAP Tools and convert to Formulas. It will create cubevalue formula from the pivot table. My question is not to discuss if it makes sense or not to use cubevalue with #, I'd like to know if it is a bug or not.

Resources