Forum Discussion

Kumar11109's avatar
Kumar11109
Helper IV
9 years ago
Solved

Calculation SD and Average

Hi All, I have a question.that I need to calculate average and SD for total time spent for each session on power bi. I am attaching an image for the sample data.   I have used the below formula. ...
Need Help
  • Kumar11109's avatar
    Kumar11109
    9 years ago

    Thank You, As it contained duplicate values so I created another table containing the required values, then used the Sd and average from that table. 

    Thank You, for your reply though. Really appreciate. 

     

    Regards, 

    Kumar Ashwarya

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Kumar11109,

 

There are a lot of duplicate data in your table, you can try to calculate the summary table which remove the duplicate records, for example:

 

Standard DeviationTest = STDEVX.S(SUMMARIZE(ALL(Sheet1),Sheet1[Resource ID],Sheet1[Total Time Spent]),[Total Time Spent])

 

Regards,

Xiaoxin Sheng

  • Kumar11109's avatar
    Kumar11109
    Helper IV
    9 years ago

    Thank You, As it contained duplicate values so I created another table containing the required values, then used the Sd and average from that table. 

    Thank You, for your reply though. Really appreciate. 

     

    Regards, 

    Kumar Ashwarya