Hi, i'm trying to build a running total by hour.
I have a power pivot CUBE formula for the time:
=IFERROR(CUBEMEMBER("ThisWorkbookDataModel","[TIME].[TIME].&[1899-12-30T10:00:00]"),"")
And what i need is to see the total up to this hour. I'm pulling in last years values. If the hour is after now then blank, else put in LY running sales.
=N(CUBEVALUE("ThisWorkbookDataModel",$A7,$A$2,"[Measures].[1YR AGO SALES NET RETAIL]",Slicer_CURRENT_DAY))
A2 is the location look up, and A7 is the hour look up.
Thanks
I have a power pivot CUBE formula for the time:
=IFERROR(CUBEMEMBER("ThisWorkbookDataModel","[TIME].[TIME].&[1899-12-30T10:00:00]"),"")
And what i need is to see the total up to this hour. I'm pulling in last years values. If the hour is after now then blank, else put in LY running sales.
=N(CUBEVALUE("ThisWorkbookDataModel",$A7,$A$2,"[Measures].[1YR AGO SALES NET RETAIL]",Slicer_CURRENT_DAY))
A2 is the location look up, and A7 is the hour look up.
Thanks