Forum Discussion
Standard Deviation for a Calculated Measure
Hi,
I am trying to calculate the standard deviation of a Measure in Power BI. The measure calculates the LN return of price changes. When I try to use the function for stadnard deviation below, I only get zeros.
11 Replies
Hi Anonymous ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) We can create a measure.
LN Return StDev = STDEVX.P(TOPN(10,FILTER(ALL('Table'),'Table'[date]<=MAX('Table'[date])),[date],DESC),'Table'[_LN Return])(3) Then the result is as follows.
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
As my pbix shows, the 'Table'[_LN Return] in the LN Return StDev measure is also the measure.
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
Hi,
Create the expected result table in an MS Excel file (with the formulas already there) and share the download link of that file.
Share the file when you can from a non work laptop.
Hi,
Please find attached my solution file. My answers do not match with your but my workings are correct. Surprisingly, for 13/9/2023, the LN function in MS Excel reveals the answer as 0.00162, the same function returns the result as 0.00216 in PowerBI.
Hope this helps.
