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
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
That would work perfectly if I wasnt trying to insert the STDEV into every column of month that the end-user selects. I need that value in each column for month to develop the UCL and LCL. I went in an rewrote the query and it looks like it now works ok so I can close this out. Basically instead of having each row represent 1, I rewrote the query in SQL to group the totals. I then was able to calculate the STDEV properly and then the UCL and LCL to get this functioning. Thanks so much for taking the time to help me with this.
I'm happy it is working for you with your extra touch! You are welcome!