Reply
Frequent Visitor
Posts: 2
Registered: ‎11-27-2018
Accepted Solution

Standard deviation

Hi All,

 

I am using  T-OLAP as the the datasouce . Please let me know the DAX  query how  to create standard deviation for the measure only for last 16  weeks.

 

Regards,

Ranga Naik


Accepted Solutions
Community Support Team
Posts: 1,730
Registered: ‎06-24-2018

Re: Standard deviation

Hi @ranganna_naik,

Based on my research, you could ues the STDEV.S Function to calculate the standard deviation:

https://docs.microsoft.com/en-us/dax/stdev-s-function-dax

 

Regards,

Daniel He

 

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Community Support Team
Posts: 1,730
Registered: ‎06-24-2018

Re: Standard deviation

Hi @ranganna_naik,

Based on my research, you could ues the STDEV.S Function to calculate the standard deviation:

https://docs.microsoft.com/en-us/dax/stdev-s-function-dax

 

Regards,

Daniel He

 

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Community Support Team
Posts: 1,730
Registered: ‎06-24-2018

Re: Standard deviation

Hi @ranganna_naik,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.