How to calculate monthly average

[Anonymous]

I have a Date column 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
1/1/2021	150	100
1/2/2021	100	100
1/20/2021	50	100
2/5/2021	300	200
2/10/2021	100	200

[Fowmy · Accepted solution]

@Anonymous 

Add the following column:

Avg = 
var __my = FORMAT(Table[Date],"mmyy") return
CALCULATE(
    AVERAGE(Table[Value]),
    FILTER(
        Table,
        format(Table[Date],"mmyy") = __my)
)