topic Re: Averaging to the current day of the month in DAX Commands and Tips

Averaging to the current day of the month

netanel — Thu, 30 Dec 2021 06:58:38 GMT

HI All!

Please I would be happy to help here!

I have this formula:

Net USD try =

CALCULATE(

DIVIDE( SUM( 'Revenues DB'[Net USD] ), COUNTROWS( 'Date' ) ),

'Revenues DB'[Date] < TODAY()

)

The formula divides by the number of days in the month of say January so it divides by 31
I want her to divide the number of days in a month only until the current day
For example we are on December 27th so you will only split in 27 days and not in 31st

Can you help please?

Re: Averaging to the current day of the month

wdx223_Daniel — Thu, 30 Dec 2021 07:40:33 GMT

Net USD try =

CALCULATE(

DIVIDE( SUM( 'Revenues DB'[Net USD] ), COUNTROWS( 'Date' ) ),

keepfilters( 'Date'[Date] < TODAY())

)

Re: Averaging to the current day of the month

netanel — Thu, 30 Dec 2021 12:08:50 GMT

Hi wdx223_Daniel

Thanks for the direction and guidance
It helped me a lot!