Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts
Need help to work out the Standard deviation of the following data set as shown below
The excel formula is = STDEVPA(Range) of the below data
the Answer is 5.6% of the below numbers
My Measure is
STD =
Calculate(STDEV.P(Llo_Data[Net Amt %]), Allexcept(Llo_Data,Llo_Data[Date]))
not getting even close with the above measure.
Solved! Go to Solution.
Same result without ALLEXCEPT
Some transformation might need to be applied on your Excel file.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
@Anonymous the syntax you wrote is correct and it is producing the same value as your Excel workbook.
Please check this sample file
You may take a look at the relationships.
Hi @Anonymous
Could it be because you are using a filter "ALLEXCEPT"!! Try without it.
STD = STDEV.P(Llo_Data[Net Amt %])
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi Amine - Nope - thanks for the feedback not correct. not getting STD = 5.6%
Same result without ALLEXCEPT
Some transformation might need to be applied on your Excel file.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Yes... the syntax is not the issue. There's another underlying reason.
Hey how about you share a file with us, can't keep speculating on what's wrong...
But try STEDV.S first instead of P
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Thanks for the feedback and apologies for not sharing a file (PBIX).
Welcome
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |