Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

 

 

 

 

 

 

 

 

 

 

 

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.

Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Same result without ALLEXCEPT

     

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

     

8 Replies

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hi Anonymous 

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

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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

      • aj1973's avatar
        aj1973
        Icon for Community Champion rankCommunity Champion
        5 years ago

        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

  • Mohammad_Refaei's avatar
    Mohammad_Refaei
    Icon for Solution Specialist rankSolution Specialist
    5 years ago

    Anonymous 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.