+ Reply to Thread
Results 1 to 5 of 5

Create Average within measures

  1. #1
    Registered User
    Join Date
    07-08-2014
    Location
    Detroit, US
    MS-Off Ver
    2010
    Posts
    7

    Create Average within measures

    Hi All,
    I am wondering if its possible to get an average list of created measure.

    Basically I have powerpivot flat table that have the following list :

    List Measure1 Measure2 Measure3 Measure4 Measure5
    aa 3 4 2 0 0
    bb 2 1 8 4 2

    Would like to have

    List Measure1 Measure2 Measure3 Measure4 Measure5 Measure 6

    aa 3 4 2 0 0 3
    bb 2 1 3 8 2 4


    Measure6 = avg( measure1:measure5)



    Thanks all

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Create Average within measures

    Does zero not count towards the average?
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    07-08-2014
    Location
    Detroit, US
    MS-Off Ver
    2010
    Posts
    7

    Re: Create Average within measures

    Thanks..No we need to exclude the zero's - exclude the count. Otherwise it will be straight forward
    i.e measure1 + measure2 +measure3 + measure4 /4.

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Create Average within measures

    What's your answer to Scott's question here: http://www.mrexcel.com/forum/powerpi...ml#post3865619 ?

  5. #5
    Registered User
    Join Date
    07-08-2014
    Location
    Detroit, US
    MS-Off Ver
    2010
    Posts
    7

    Re: Create Average within measures

    Thanks -the Scott solution works

+ 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. Excel 2007 : Repeated-measures ANOVA
    By Layo909 in forum Excel General
    Replies: 0
    Last Post: 04-21-2011, 01:52 AM
  2. Worksheet Security Measures
    By smlaff01 in forum Excel General
    Replies: 0
    Last Post: 08-13-2007, 12:49 PM
  3. [SOLVED] Calculating % of different measures taken
    By Goran in forum Excel General
    Replies: 7
    Last Post: 04-09-2006, 07:20 AM
  4. desperate measures
    By cjjoo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-19-2005, 02:38 AM
  5. Grouping measures
    By fmilano in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-04-2005, 01:05 PM

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