Forum Discussion
STDEV DAX when using row with value 1
Hi:
Please see file. You willl notice I have summary table in and have set up a date table. I made up the data points but results appear to work as intended. What do you think?
https://drive.google.com/file/d/1ibEFS6MXsidsA3ny7_KnDY-UAnJ0UOde/view?usp=sharing
It does. What I was hoping was to get the standard deviation from the sum of each month selected in the slicer. So for instance if the end-user selects the below:
1-2020 with 1000
2-2020 with 2000
3-2020 with 1500
Then in simple form calculate the standard deviation of those three which would be STDEV(1000, 2000, 1500)
Hi:
Maybe your sample data isn't matching your latest example. I see 1 for Jan 2020 but you mention it is 1000? Do you have sample data to share? Just something to represent this issue so I can see those different totals. Thanks