Averaging to the current day of the month

[netanel]

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?

[wdx223_Daniel · Accepted solution]

Net USD try =

CALCULATE(

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

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

)

[netanel]

Hi @wdx223_Daniel 

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