Standard deviation for sum of weekly

[Anonymous]

Data table
Device ID	Date time	SKU
Device 1	dd/mm/yy hh:mm:ss	Sku1
Device 2	dd/mm/yy hh:mm:ss	Sku2
Device 3	dd/mm/yy hh:mm:ss	Sku3
Device 4	dd/mm/yy hh:mm:ss	Sku1
Device 5	dd/mm/yy hh:mm:ss	Sku1
Device 1	dd/mm/yy hh:mm:ss	Sku1
Device 2	dd/mm/yy hh:mm:ss	Sku2
Device 3	dd/mm/yy hh:mm:ss	Sku3
Device 4	dd/mm/yy hh:mm:ss	Sku3
Device 5	dd/mm/yy hh:mm:ss	Sku10
Device 6	dd/mm/yy hh:mm:ss	Sku11
Device 7	dd/mm/yy hh:mm:ss	Sku12
Device 8	dd/mm/yy hh:mm:ss	Sku13

the QTY of SKU is always 1 for each line of event, so the number of consumption is : Count [SKU] ( or count any column in that table) 

I have a calendar table for assigning week number

How do i get the the StD in PBI? 

[v-lili6-msft]

hi  @Anonymous 

For your case, create a measure as below:

Measure = STDEVX.P('calendar',CALCULATE(COUNTA('Table'[SKU])))

https://docs.microsoft.com/en-us/dax/stdevx-p-function-dax

Regards,

Lin

[pranit828]

Hi @Anonymous 

create a column as

_weeknum = WEEKNUM('Table'[Date Time])

then create a measure as 

Std_Dev_Qty = CALCULATE(STDEV.P(table[SKU]),ALLEXCEPT(table,table[Devide ID],Email[Dow]))

Change SKU to the desired column on which you need the STDV.P