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 stan...
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 )

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.