Forum Discussion

Riddell2023's avatar
Riddell2023
New Member
4 years ago
Solved

Standard Deviation HELP!!!

Good Afternoon, I am really struggling with a DAX calculation to do the same as the above. Please could someone help as I am pulling my hair out
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Riddell2023 

     

    Please check the following methods.

    Column:

    En SdDev Diff =
IF (
    [Band] <> BLANK (),
    ROUND ( [En Diff] / STDEV.S ( 'Table'[Assessment% ] ), 2 ),
    BLANK ()
)

    Are some of our results inconsistent because there are hidden decimal points in the data image you provided?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.