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 I don't understand how that figures into the problem.  Can you provide additional info?

netanel's avatar
netanel
Post Prodigy
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