Solved: Need Help Urgently: DAX Formula

JB17 · ‎05-31-2022

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 · ‎05-31-2022

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] )

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

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Jihwan_Kim · ‎05-31-2022

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] )

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

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Need Help Urgently: DAX Formula