How to get average, based on selected Year and Month

[MarshalSK]

Hi Folks, Need your assistance to get calculated, Average Sales based on selected year and month.

expected result:

Year	Month	Sales
2011	Jan	100
2011	Feb	200
2011	Mar	300
2011	Apr	500
2011	May	100
2011	Jun	200
2011	July	300
2012	Jan	400
2012	Feb	100
2012	Mar	200
2012	Apr	300
2012	May	100
2012	Jun	900

[v-junyant-msft · Accepted solution]

Hi @MarshalSK ,

Just use this DAX:

Average = AVERAGE(Sheet15[Sales])

The final output is below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.