Forum Discussion

HarryS's avatar
HarryS
Helper I
7 years ago
Solved

Standard Deviation issue

Hello, Bit of a strange request. My organisation recently started using Power BI and we are transitioning from our old way of reporting to equivalent Power BI Dashboards and struggling a bit with ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    HarryS -

    You can do the following:

     

     

    Std Dev = 
var a = SUMMARIZE(yourtable,yourtable[Date],"countitems", COUNT(yourtable[ID]))
return STDEVX.P(a,[countitems])
    Mean = 
var rowcount = COUNTROWS(yourtable)
var datecount = DISTINCTCOUNT(yourtable[Date])
return DIVIDE(rowcount,datecount)

    Cheers!

    Nathan

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HarryS -

You can do the following:

 

 

Std Dev = 
var a = SUMMARIZE(yourtable,yourtable[Date],"countitems", COUNT(yourtable[ID]))
return STDEVX.P(a,[countitems])
Mean = 
var rowcount = COUNTROWS(yourtable)
var datecount = DISTINCTCOUNT(yourtable[Date])
return DIVIDE(rowcount,datecount)

Cheers!

Nathan

 

HarryS's avatar
HarryS
Helper I
7 years ago

Hello Nathan,

Thank you very much for your help, that seems to work. I'll have a go trying a few different things with it and make sure it's fit for purpose. Thanks again.

Best wishes,

Harry