Forum Discussion

kheldar's avatar
kheldar
Iron Contributor
Dec 09, 2021
Solved

GetPivotData and Time Values as Cell References

Hello, I seriously think that this is a bug. Actually maybe more than one bug.   First;   Using regular data model, if the source data includes a time value such as 00:00, you can't display tho...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Dec 09, 2021

    kheldar 

    I'd avoid using of implicit measures and GETPIVOTDATA(). For such sample

    we may create explicit measure

    Values sum:=SUM( [Value] )

    and return related value by

    =CUBEVALUE( "ThisWorkbookDataModel",
       CUBEMEMBER( "ThisWorkbookDataModel", "[Table1].[Time].[" & TEXT( $K$4, "hh:mm" ) & "]"),
       CUBEMEMBER("ThisWorkbookDataModel", "[Measures].[Values sum]") )

    In the sample above time is selected from drop down list, please see attached.

kheldar's avatar
kheldar
Iron Contributor
Dec 15, 2021

Thank you! I managed to get it done by changing it to table name! You are super helpful. I can't thank you enough!

Resources