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 %])