Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

PreviousQuarter Function Not Working

 

 

What this is supposed to be doing is averaging the highlighted values (Quarter 1 values) and taking the average of them. However, 87.10 isn't correct. By hand if I do:

(86.67+87.10+83.87)

_____________________

                 3

 

I should be getting 85.88. Why is not coming out to that??? It just picked February's number and returned it....

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi

    Use  Avg = SUMX( VALUES( Table1[EMS AM]), Table1[Retention] ) / 3  // ( Or calculate the count as needed).

     

    Hope this helps.

     

    Thanks
    Raj

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    This could be because of 'Retention' variable. If you have already used some formula to derive 'Retention', try splitting the steps , like find the sum and count in 2 steps and find the avg in 3rd step.

     

    Thanks
    Raj

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi

      Use  Avg = SUMX( VALUES( Table1[EMS AM]), Table1[Retention] ) / 3  // ( Or calculate the count as needed).

       

      Hope this helps.

       

      Thanks
      Raj