Forum Discussion

netanel's avatar
netanel
Post Prodigy
4 years ago
Solved

Daily AVG

Hi All!   I have this maesure: Net USD AVG = CALCULATE( DIVIDE( SUM( 'DB 2022'[Net USD] ), COUNTROWS( 'Date' ) ), keepfilters( 'Date'[Date] < TODAY()) ) It works great It divides the Data ...
Need Help
  • littlemojopuppy's avatar
    littlemojopuppy
    4 years ago

    Hi netanel.  This should calculate a daily average for all dates in the filter context

    Daily Average =
AVERAGEX(
	VALUES([Your date field]),
	SUM('DB 2022'[Net USD])
)

     

    Hope this helps!

  • netanel's avatar
    netanel
    4 years ago

    Hi littlemojopuppy  thanks for the response!

     

    Problem number 1:

     

     

     

     

     

     

     

     

    Problem number 2:

    I can not share my data but
    Problem number 2 is simple and I overcame it in my formula above
    The problem is that if every day I get 5000
    So when I go up to the monthly level instead of getting an average of 5000 for January I get 31 times 5000 that it comes out to 155,000
    And if I go up to the quarter level then I get 155K double 3

littlemojopuppy's avatar
littlemojopuppy
Community Champion
4 years ago

netanel awesome!  I'm glad that what I suggested you try ended up being the solution!  ğŸ˜Š

netanel's avatar
netanel
Post Prodigy
4 years ago

littlemojopuppy 

Who defined this as a solution?
Nothing was resolved
And I did not define it as a solution ...

  • littlemojopuppy's avatar
    littlemojopuppy
    Community Champion
    4 years ago

    netanel you said that you overcame your issue with the solution in the pic you supplied, which was exactly what I suggested.  The other issue you mentioned is from information not included in the initial request...

    • netanel's avatar
      netanel
      Post Prodigy
      4 years ago

      littlemojopuppy 

      Maybe I accidentally clicked on Get a solution and iam sorry for that.


      But in the picture you can see that I get the 31st per month even though I am only on the 18th of the month
      Or my data is only up to the 16th of the month
      This is one problem

      Problem number two
      When rising to a monthly or quarterly level there is no calculation of average at all