Need Help Urgently: DAX Formula

[JB17]

Hi,

Good day! Can you help me on DAX formula for below table? 

I want to get the score average of the ID for the month of May so that when I show it on trend it would not show four scores.

Thanks in advance!

[Jihwan_Kim · Accepted solution]

Hi, 

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

I suggest having a DIM-Calendar table like the attached pbix file.

AVG score measure: = 
    AVERAGE( Data[Score] )