Forum Discussion

ask's avatar
ask
Helper III
9 years ago

Standard Diviation

I have a set of data for student's score for 2 years. i will get the standardard deviation of list of student on picked day. how to do that?  Output will look like this.    Name Score Standard...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi ask,

 

I don't see any Date column in your sample table above. Anyway, it doesn't matter.

1. Add [Year], [MonthName], [WeekName] column to your table if you have them yet.

Year = YEAR(data[Date]) 
MonthName = FORMAT(data[Date],"MMMM") 
WeekName = FORMAT(data[Date],"DDDD")

I knew your table doesn't have Year, Month, Week. As I have mentioned in Step 1: You need to add them first!!(just use the formula I have provided above)

 

Regards

ask's avatar
ask
Helper III
9 years ago

v-ljerr-msftMy requirement doesn't allow me to create slicer. Any way to calculate the SD by each name, by specific date?