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
Community 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
    Community Champion
    5 years ago

    Welcome