How to calculate monthly average

[Anonymous]

I have a column with days and I need to calculate the average value for each month by repeating that value for every day of that month.

Example,

Date	Value	Average
01/01/2021	150	100
01/02/2021	100	100
01/20/2021	50	100

[Jihwan_Kim]

Hi, @Anonymous 

Please check the below picture and the sample pbix file's link down below.

I tried to create an extended version of the sample pbix file based on the explanation.

Avg Monthly Measure =
VAR currentmonth =
EOMONTH ( MAX ( 'Table'[Date] ), 0 )
RETURN
IF (
ISFILTERED ( 'Table'[Date] ),
AVERAGEX (
FILTER ( ALL ( 'Table' ), EOMONTH ( 'Table'[Date], 0 ) = currentmonth ),
'Table'[Value]
)
)

https://www.dropbox.com/s/zoduiw4db8ddk94/luizabolon.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM