Hi I have a cube formula below. But my issue is I want it to pull the date from my Slicer_DATE and time from a cell list.
I have a list of the hours we are open and a slicer for date and would like to modify the formula to use that info.
=CUBEVALUE("ThisWorkbookDataModel","[MachineCode].[machine_code].&[" & $C$4 & "]",{"[dCalendar].[DATES].&[2017-10-02T00:00:00]","[SALES TABLE].[TIME (Hour)].&[10]"},"[Measures].[SALES TOTAL NET RETAIL]")
Thanks
I have a list of the hours we are open and a slicer for date and would like to modify the formula to use that info.
=CUBEVALUE("ThisWorkbookDataModel","[MachineCode].[machine_code].&[" & $C$4 & "]",{"[dCalendar].[DATES].&[2017-10-02T00:00:00]","[SALES TABLE].[TIME (Hour)].&[10]"},"[Measures].[SALES TOTAL NET RETAIL]")
Thanks
