cube formula

I've been using this CUBESET function without issue for a couple of weeks to calculate a sum between two dates, but today it's giving me an #N/A error...

Hey all, I have tried to the following CUBE formulas in order to get a value based on results from two columns within a dataset inside Power Pivot, however they all return blank. =CUBEVALUE("ThisWorkbookDataModel","[Measures].[Path PP Plan Yes]", "[Path].[Pathway Plan].No", "[Service...

Hi all, I am having trouble with picking out only blank values in my CUBE formula. Hope someone can help? =CUBEVALUE("ThisWorkbookDataModel","[Measure].[Assessment a.exceeds 45 days]","[Assessment].[Step End Date].["&""&"],"[Service Area].["&A16&"]") Section in bold is where i wish to enter...

Hi I'm trying to build a formula that has the running total by hour. I use CUBE members Here is the hourly cube: =IFERROR(CUBEMEMBER("ThisWorkbookDataModel","[TIME].[TIME].&[1899-12-30T10:00:00]"),"") This is the sales formula pointing to the hour above...

Hi I'm trying to write a cube function that has just todays sales. Currently i have a slicer for month and year. =CUBEVALUE("ThisWorkbookDataModel","[Measures].[SALES TOTAL NET RETAIL]",Slicer_MONTH1,U$6,Slicer_YEAR1) But I would like to have just today. IE TODAY() I've tried this but that...

Hi I have a cube function with an issue. How do I handle any part of the equation where there is not values. There are 3 formulas and i receive a #Value if there is nothing for any part of the formula. =CUBEVALUE("ThisWorkbookDataModel","[Measures].[1YR AGO OH RETAIL]",'MONTHLY...

Hi, I am having trouble finding resources on how to use wildcards in Excel Cube formulas. I use rollup coding for my gl accounts to create my financial statements. So I attach a code to my wage accounts like "WAGES-OPERATING" for my operating fund; and "WAGES-CAPITAL" for wages in my capital...

Hi all I really hope you can help with this issue as it is driving me qrazy. I have build a really nice PowerPivot model and I am now in the process of setting up an end user friendly excel report in which I use cube formulas. I normally create a suitable pivottable and then convert it to...

Hello, I searched the forums but haven't seen this issue yet... When using cube formulas that are driven by measures and cubesets driven by formulas, I receive the #N/A error when I deselect from a slicer. This is generated because the cubeset formula for that slicer throws an #N/A... Has...

One of my favorite features in PowerPivot are slicers and sometimes there is a need to have more than one slicer of the same kind. I think best example is a comparison of a measure for 2 different periods and you want to select both of the periods that you want to compare. In a pivot this...

Hi, I wonder if it is possible to connecting PowerPivot data from another Excel file? I have a file DATA.xlsx which contains loads of PowerPivot data. Then I have a file for reporting (REPORT.xlsx). In this file I would like to grab values from the PowerPivot model in DATA.xlsx with using cube...