Forum Discussion

M0n5ta09's avatar
M0n5ta09
Icon for Helper I rankHelper I
4 years ago
Solved

HELP - Standard Deviation

Hi everyone,   I've been trying for hours to calculate the Standard Deviation by month and by year based on _Faults per Day but getting nowhere. I'm expecting the STDEV to be around 0.75 for 2017 ...
Need Help
  • ALLUREAN's avatar
    ALLUREAN
    4 years ago

    Can you try this measure:

    STDEV (LongTerm) = STDEV.S([_Faults per Day])
     

    Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

    Appreciate your Kudos !!!

    https://allure-analytics.com/

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

M0n5ta09 , Try like

calculate(Stddev.p(Table[_Mean - Faults per Day]), allexcept(table[Year]))

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.