Search:

Type: Posts; User: PerryN1; Keyword(s):

Search: Search took 0.00 seconds.

  1. Days/rows since 'certain value' for individuals

    Hi, running PowerPivot in excel 2016, say I have a group of 10 persons, and for every day the 10 persons record a score. I'm wanting to find how many days (or rows given that each row is a different...
  2. Replies
    5
    Views
    1,891

    Re: PowerPivot 'Infinity' Issue

    Thanks a lot for your help Ozeroth, the allexcept seems to work fine.

    That was going to be my other question, why would it work in 2013 but not 2016!? Hopefully won't encounter too many other...
  3. Replies
    5
    Views
    1,891

    Re: PowerPivot 'Infinity' Issue

    ...Minus all the TD and TRs, not sure where they appeared from!
  4. Replies
    5
    Views
    1,891

    Re: PowerPivot 'Infinity' Issue

    <table verdana,="" arial,="" tahoma,="" calibri,="" geneva,="" sans-serif;"=""><tbody>
    To provide some more info using just the stdev as this is where the issue lies...

    This is the table in...
  5. Replies
    5
    Views
    1,891

    PowerPivot 'Infinity' Issue

    Hi,
    i currently have the following table..

    Day Date MD Mode Person Volume VolumeMDAvg VolumeZscore


    VolumeMDAvg is the average volume filtered by person and MD.

    Im currently getting an...
  6. Replies
    8
    Views
    612

    Re: PowerPivot Averages

    Ah ok I understand where you're coming from, will have a play around. Thanks for your help!
  7. Replies
    8
    Views
    612

    Re: PowerPivot Averages

    Using =average(MyTable[Score1]) returns the average for all of the 'persons' for the whole table. The average needs to be filtered to the 'person' and also the 'ND'. I'm sure I explained this...
  8. Replies
    8
    Views
    612

    Re: PowerPivot Averages

    Forget that score2 even exists...

    Date | Day_ID | Person | Score1 | Score1_ND_Avg

    08/02/14 | ND1 | Person1 | 10 | 15
    08/02/14 | ND1 | Person2 | 13 | 14
    08/02/14 | ND1 | Person3 | 7 | 9.5...
  9. Replies
    8
    Views
    612

    Re: PowerPivot Averages

    Thanks but not quite what I'm after. I'm basically after the Score1_ND_Avg column below...and then will repeat for score2/score3 etc.

    Date | Day_ID | Person | Score1 | Score2 | Score1_ND_Avg
    ...
  10. Replies
    8
    Views
    612

    PowerPivot Averages

    Hi all, I'm running Powerpivot in excel 2013 and have a table data whereby a list of people complete several tasks once per day, e.g.

    Date | Day_ID | Person | Score1 | Score2 | Score3

    08/02/14...
  11. Replies
    6
    Views
    1,269

    Re: Rolling Average in Athlete Database

    Another question Tianbas, I now have the following table:

    Week|Date|Player|Score1|Score2|Score3|Score1_Last8WeekAvg|Score2_Last8WeekAvg|Score3_Last8WeekAvg

    In a separate table I have fixed...
  12. Replies
    6
    Views
    1,269

    Re: Rolling Average in Athlete Database

    Yeah it does work actually, many thanks for your help!
  13. Replies
    6
    Views
    1,269

    Re: Rolling Average in Athlete Database

    Thanks Tianbas,

    Unfortunately I got the following error:

    Too few arguments were passed to the FILTER function. The minimum argument count for the function is 2.

    Any ideas?
  14. Replies
    6
    Views
    1,269

    Rolling Average in Athlete Database

    Hi all, I'm running Powerpivot in excel 2013 and have several tables of data whereby a squad of players complete a several tasks once per week, e.g.

    Date Player Score1 Score2 Score3
    ...
Results 1 to 14 of 14