cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Route217
Post Prodigy
Post Prodigy

Standard deviation in Power BI

Hi Experts

 

Need help to work out the Standard deviation of the following data set as shown below

 

The excel formula is = STDEVPA(Range) of the below data

 

the Answer is 5.6% of the below numbers

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

My Measure is

STD = 
Calculate(STDEV.P(Llo_Data[Net Amt %]), Allexcept(Llo_Data,Llo_Data[Date]))

 

not getting even close with the above measure.

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

Same result without ALLEXCEPT

aj1973_0-1627137514754.png

 

Some transformation might need to be applied on your Excel file.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

8 REPLIES 8
Mohammad_Refaei
Solution Specialist
Solution Specialist

@Route217 the syntax you wrote is correct and it is producing the same value as your Excel workbook.

Please check this sample file

 

You may take a look at the relationships.

aj1973
Community Champion
Community Champion

Hi @Route217 

Could it be because you are using a filter "ALLEXCEPT"!! Try without it.

STD = STDEV.P(Llo_Data[Net Amt %])

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Hi Amine - Nope - thanks for the feedback not correct. not getting STD = 5.6%

aj1973
Community Champion
Community Champion

Same result without ALLEXCEPT

aj1973_0-1627137514754.png

 

Some transformation might need to be applied on your Excel file.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

Yes... the syntax is not the issue. There's another underlying reason.

aj1973
Community Champion
Community Champion

Hey how about you share a file with us, can't keep speculating on what's wrong...

But try STEDV.S first instead of P

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Thanks for the feedback and apologies for not sharing a file (PBIX). 

aj1973
Community Champion
Community Champion

Welcome

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors