+ Reply to Thread
Results 1 to 4 of 4

Error in formula in powerpivot

  1. #1
    Registered User
    Join Date
    02-09-2015
    Location
    Bangalore
    MS-Off Ver
    2013
    Posts
    32

    Error in formula in powerpivot

    Hi,

    I am using this formula & am getting an error:

    =CALCULATE([Time_Between_Update],Sheet1[Scope]=1)

    The error is: Column 'Time_Between_Update' cannot be found or may not be used in this expression.

    Can someone help me with this.

    Regards,
    Sid.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Error in formula in powerpivot

    Hello,

    you are referring to Sheet1 in the formula. Is there a relationship to Sheet1? Calculate only works with properly configured relationships between tables, and you may also need to use the Filter() function to narrow down the relevant results.

  3. #3
    Registered User
    Join Date
    02-09-2015
    Location
    Bangalore
    MS-Off Ver
    2013
    Posts
    32

    Re: Error in formula in powerpivot

    Hi teylyn,

    There is only one sheet and the formula is being written in a column in the same sheet where the two columns are present.

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Error in formula in powerpivot

    It's not clear what the problem is. Post a sample file.

+ 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. PowerPivot Refresh Error
    By chils in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-30-2014, 04:25 PM
  2. Replies: 2
    Last Post: 06-02-2014, 09:34 AM
  3. [SOLVED] Powerpivot import error
    By Reykjavik in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 03-19-2013, 02:22 PM
  4. Replies: 0
    Last Post: 11-20-2012, 05:34 AM
  5. PowerPivot Importing Error
    By amotto11 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-28-2011, 01:40 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