Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ortignano
Helper I
Helper I

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
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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 )

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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 )

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

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors