cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Prodigy

## 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

Mark my post as a solution!

1 ACCEPTED SOLUTION
Super User

@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 2
Super User

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.

Super User

@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]))
)