Skip to main content
cancel
Showing results for
Search instead 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

Did I answer your question?
Mark my post as a solution!
Appreciate your Kudos!

Connect on Linkedin
linkedin.com/in/netanel-shriki
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.

Appreciate your Kudos!!

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

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors