Forum Discussion

adbm's avatar
adbm
Helper I
1 year ago

Mean value not calculated correctly

Hi,   I have a table with ~24K rows of invoice data of various vendors. Im trying to add a calculated column to find the average of a column called 'Days to Payment' by vendor. So for every row, i ...
Need Help
adbm's avatar
adbm
Helper I
1 year ago

Hi Selva-Salimi  - thakns for that, but  it doesn't help unfortunately; still showing the same incorrect average value

 

 

 

 

Selva-Salimi's avatar
Selva-Salimi
Solution Sage
1 year ago

adbm 

Ok, then rewrite it as follows:

 

CALCULATE(Sum('Vendor data'[Days to Payment]),filter('Vendor data','Vendor data'[Name] = earlier('Vendor data'[Name]))) / CALCULATE(count('Vendor data'[Days to Payment]),filter('Vendor data','Vendor data'[Name] = earlier('Vendor data'[Name])))

 

If this post helps, then I would appreciate a thumbs up 👍 and mark it as the solution to help the other members find it more quickly. 

 

  • adbm's avatar
    adbm
    Helper I
    1 year ago

    Hi Selva-Salimi 

     

    Thanks -- but sorry no luck still. see below

     

     

    • Selva-Salimi's avatar
      Selva-Salimi
      Solution Sage
      1 year ago

      adbm 

       

      please go to Direct query, refresh your data and filter this table to the "Name" that was shown on the previous image you shared and then share that data. I am sure that the problem is not in formula. it might be in your data.