Forum Discussion
Remove outliers based on standard deviation
Community SupportHi, flavio29
I was unable to reproduce your column using your formula above. Is the formula above a measure or a calculated column? Could you use the data to give an example of how you get the desired result
Would you consider providing sample files?
Where I am:
It makes it easier to give you a solution.
- Sample (dummy dataset) data as text, use the table tool in the editing bar
- Expected output from sample data
- Explanation in words of how to get from 1. to 2.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello, v-angzheng-msft
The formulas are all measures. Below is a print of an example of my data:
Just added the column "element of code", i dont think thats relevant becuase i dont need that for the formulas. Ignore the total becuase there is more data than that in the table.
For the average per month or another concatenated data the values dont appear like i mentioned above, but if i concatenate the data in a table by month or year it gives the right result. Similar to standard deviation i used this for the average:
Avg values per month = AVERAGEX(VALUES('Table'[Code]),[Avg values per code])
The major problem for me is what comes next because i can't remove the outliers based on the standard deviation like i showed previously. In the end i need a table for example like this (with corrected values which i don't have right now):
Is it because the formulas are in measures instead of calculated columns?
Thanks for the attention.