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 nu...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Same result without ALLEXCEPT

     

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

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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

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

        Welcome

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

    Same result without ALLEXCEPT

     

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

     

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

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