What is a cubevalue

[stephme55]

There is this formula in a spreadhsheet. What is a cubevalue?

="Last Refreshed: " & TEXT(CUBEVALUE("ThisWorkbookDataModel","[Measures].[LastRefreshed]"),"mm/dd/yyyy")

[TMS]

Google: cubevalue function


https://support.office.com/en-us/art...a-84a8f00dcbe0

[MrShorty]

These are not functions I am familiar with. Perhaps a few Google hits to start your research.

The Excel help files for the CUBE...() functions: https://support.office.com/en-us/art...__toc309306707

One introduction to some of the CUBE...() functions: http://thatmsftbiguy.com/excelcubefunction/

Another: https://blogs.office.com/2006/02/06/...examples/#ttop

And another: https://channel9.msdn.com/Events/Tec...nd/2013/DBI304

These were found by putting "cube functions" into google.

[stephme55]

Cool. Thanks!!