Forum Discussion

nehajadhav166's avatar
nehajadhav166
Resolver I
3 years ago
Solved

Stdev.s giving incorrect value

Hi Experts,   In my Cpk calculation, I see STDEV.S is giving incorrect value. Data set I have as below -11.67 -11.71 -11.67 -11.67 -11.69 -11.65 -11.68 -11.67 -11.63 ...
Need Help
  • nehajadhav166's avatar
    nehajadhav166
    3 years ago

    v-jianboli-msft ,

     

    Issue is resolved now. There was data discrepency when I am loading data using M query. I removed some colunms and removed duplicate values. Now its working fine.

    There is no issue with STDEV.S and STDEV.P calculation in power BI.

     

    Thanks,

    Neha

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi nehajadhav166 ,

 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

 

Best Regards,

Jianbo Li

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

  • nehajadhav166's avatar
    nehajadhav166
    Resolver I
    3 years ago

    v-jianboli-msft ,

     

    Issue is resolved now. There was data discrepency when I am loading data using M query. I removed some colunms and removed duplicate values. Now its working fine.

    There is no issue with STDEV.S and STDEV.P calculation in power BI.

     

    Thanks,

    Neha