Forum Discussion

mweber's avatar
mweber
Frequent Visitor
7 years ago

Standard Deviation

Hello,   I'm having trouble getting the correct Standard Deviation from a dataset. Here's a subsection of a datset I'm working with: Week Ending Site SKU Nbr Units 1/6/2019 Sycamore 100...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

mweber 

It can be a little tricky. Here's a couple threads that I solved with some-what the same issue. Take a look and see if they help. If not, fire away some questions here

https://community.powerbi.com/t5/Desktop/Getting-Standard-Deviation-on-counts-if-ID-rolled-off-at-month/m-p/699696

 

https://community.powerbi.com/t5/Desktop/Incorrect-Standard-Deviation-of-a-measure/m-p/736707

 

https://community.powerbi.com/t5/Desktop/Standard-deviation-on-average-weighted-price/m-p/699527

  • mweber's avatar
    mweber
    Frequent Visitor
    7 years ago

    Thanks Nick_M! I've looked through your threads and tried a couple things but not sure I'm applying them correctly. So I created this measure to calculate Avg. Weekly Sales:

     

    Avg. Units per Week = SUM('Summarized Orders'[Total])/CALCULATE(DISTINCTCOUNT('Summarized Orders'[Calendar Week End]))
     
    I was thinking maybe then there was a way to leverage that measure. Tried the addcolumns with no success.
     
    Thanks again for the assistance!