Forum Discussion

netanel's avatar
netanel
Post Prodigy
4 years ago
Solved

Daily AVG Sum

Hello everyone!
I have a formula for calculating a daily average

 

Net USD average per Day =
AVERAGEX(
    KEEPFILTERS(VALUES('Date'[Date].[Day])),
    CALCULATE(SUM('Revenues DB'[Net USD]))
)
 
I try to do the same formula but without SUM because as soon as I rise to the level of the quarter or year the amounts is wrong
  • amitchandak's avatar
    amitchandak
    4 years ago

    netanel , Prefer to have date without timestamp and try a measure like

     


    Net USD average per Day =
    AVERAGEX(
    VALUES('Date'[Date]),
    CALCULATE(SUM('Revenues DB'[Net USD]))
    )

2 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    Hi netanel 

     

    Try this:

    Net USD average per Day =
VAR _A =
    SUMMARIZE( 'Date', 'Date'[Date], "NetUSD", SUM( 'Revenues DB'[Net USD] ) )
RETURN
    AVERAGEX( _A, [NetUSD] )

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

     

    Appreciate your Kudos!!

     

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    netanel , Prefer to have date without timestamp and try a measure like

     


    Net USD average per Day =
    AVERAGEX(
    VALUES('Date'[Date]),
    CALCULATE(SUM('Revenues DB'[Net USD]))
    )