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.

     

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

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.