values mismatch

Hi prirao0004 ,
According to your description, I did the test in excel and power bi(2.123.742.0 64-bit (November 2023)).

Here is my test data:

1 In Power BI

2 In Excel

After my testing, in excel, the STDEV function returns the same value as the STDEV in Excel.

The same function returns the same value in power bi and excel. 
You can confirm that you are using the same standard deviation formula in both Excel and Power BI. Excel has two functions for standard deviation: `STDEV.P` (population standard deviation) and `STDEV.S` (sample standard deviation). In Power BI, you can use `STDEV.P` or `STDEVX.P` for population standard deviation and `STDEV.S` or `STDEVX.S` for sample standard deviation.

If I've misunderstood you, please provide detailed sample data and the results you are hoping for.
We can better understand the problem and help you. Show it as a screenshot or excel.
Please remove any sensitive data in advance.

 

Best regards

Albert He

 

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