+ Reply to Thread
Results 1 to 5 of 5

CUBE formula that references blanks

  1. #1
    Registered User
    Join Date
    03-24-2020
    Location
    London, England
    MS-Off Ver
    365
    Posts
    15

    CUBE formula that references blanks

    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 a blank parameter. Anyone able to help?
    Using the [All] expression works so everything else with the formula is fine...

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: CUBE formula that references blanks

    Use:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    03-24-2020
    Location
    London, England
    MS-Off Ver
    365
    Posts
    15

    Re: CUBE formula that references blanks

    Thank you!!! Works smoothly.

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: CUBE formula that references blanks

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  5. #5
    Registered User
    Join Date
    06-22-2023
    Location
    Virginia
    MS-Off Ver
    Office 365
    Posts
    1

    Re: CUBE formula that references blanks

    For anyone else that stops by, I had to do "[Assessment].[Step End Date].&[]"

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to count blanks and non-blanks with a dynamic range
    By brittdyer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-12-2018, 07:45 AM
  2. Cube functions - multiple cube members same value returns inaccurate total
    By emcfportal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-03-2017, 10:59 AM
  3. Is it possible to use Cube Formula without Powerpivot?
    By liquidmettle in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-30-2015, 01:31 PM
  4. Cell References in Cube Formulae
    By rab2a in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2014, 11:39 AM
  5. cube analysis add -in for excel and local cube
    By swetha in forum Excel General
    Replies: 0
    Last Post: 07-28-2006, 04:30 PM
  6. Replies: 2
    Last Post: 07-29-2005, 10:05 AM
  7. OLAP cube and formula
    By z00 in forum Excel General
    Replies: 0
    Last Post: 01-19-2005, 12:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1