Forum Discussion

Ortignano's avatar
Ortignano
Helper II
4 years ago
Solved

Problem with STDEV

Hello,

I have  a table with error and week ID reference. I create a visual like below:

 

Error    Last7DaysError    STDEV_of_last12_week

Err 1

Err2

..

Err n

 

And I try to calculate the standard deviation of each err over the last 12 weeks using

 

STDEV_of_last12_week = STDEVX.P(FILTER(ALL('Calendar'),
'Calendar'[WeekID]<=MAX('Calendar'[WeekID]) &&
'Calendar'[WeekID]>=MAX('Calendar'[WeekID])-11
),
[CountError]
)
 
but comparing with the same table in excel it doesn't give me the correct result. I don't if I'm make some error in claculation
Thank you
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Ortignano , 12 weeks calculation seems correct try with a table having the measure or some grouping of table using values or summarize

     

    example

    STDEV_of_last12_week = calculation( STDEVX.P(Table, [CountError]) ,FILTER(ALL('Calendar'),
    'Calendar'[WeekID]<=MAX('Calendar'[WeekID]) &&
    'Calendar'[WeekID]>=MAX('Calendar'[WeekID])-11 )

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Ortignano , 12 weeks calculation seems correct try with a table having the measure or some grouping of table using values or summarize

     

    example

    STDEV_of_last12_week = calculation( STDEVX.P(Table, [CountError]) ,FILTER(ALL('Calendar'),
    'Calendar'[WeekID]<=MAX('Calendar'[WeekID]) &&
    'Calendar'[WeekID]>=MAX('Calendar'[WeekID])-11 )

    • Ortignano's avatar
      Ortignano
      Helper II
      4 years ago

      Thank you Amitchandak, it was my fault:  I didn't use a summarized table.