Forum Discussion

JB17's avatar
JB17
Frequent Visitor
4 years ago
Solved

Need Help Urgently: DAX Formula

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's avatar
    Jihwan_Kim
    4 years ago

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

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

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