Forum Discussion
Helper IIIDynamic column calculate based on slicer date range and filter by two parameters
I created some process control charts with a slicer on top by date. I need help with calculating average, stdev, and other info based on slicer date range by Step and Product. Is it possible to calculate for what I need? What would be the best option?
| Date_Time | ID | Step | Data | Product |
| 10/13/18 7:11 PM | 128396 | DEF | 7.46 | MMM |
| 10/14/18 8:08 PM | 128346 | ABC | 9.634 | YYY |
| 10/14/18 9:47 PM | 128350 | ABC | 9.565 | YYY |
| 10/14/18 10:02 PM | 128348 | ABC | 9.617 | YYY |
| 10/14/18 10:42 PM | 128373 | ABC | 9.682 | YYY |
| 12/13/18 8:00 PM | 128351 | ABC | 9.77 | YYY |
| 12/13/18 11:13 PM | 128349 | ABC | 9.772 | YYY |
| 12/13/18 11:24 PM | 128314 | ABC | 9.759 | YYY |
| 12/14/18 4:35 PM | 128308 | ABC | 9.736 | YYY |
| 12/16/18 10:21 AM | 128351 | DEF | 7.466 | YYY |
| 12/16/18 1:29 PM | 128314 | DEF | 7.442 | MMM |
| 12/16/18 1:37 PM | 128349 | DEF | 7.431 | MMM |
| 12/22/18 3:43 PM | 128292 | DEF | 7.426 | MMM |
| 12/22/18 4:02 PM | 128348 | DEF | 7.435 | MMM |
| 12/22/18 4:47 PM | 128373 | DEF | 7.403 | MMM |
| 12/23/18 4:52 PM | 128350 | DEF | 7.406 | MMM |
| 12/23/18 5:01 PM | 128390 | DEF | 7.444 | MMM |
| 12/23/18 8:38 PM | 128394 | DEF | 7.433 | MMM |
| 12/26/18 1:18 PM | 128354 | DEF | 7.481 | YYY |
| 12/26/18 1:25 PM | 128308 | DEF | 7.438 | MMM |
| 12/26/18 1:30 PM | 128325 | DEF | 7.447 | MMM |
| 12/26/18 1:35 PM | 128817 | DEF | 7.524 | YYY |
EZiamslow wrote:I created some process control charts with a slicer on top by date. I need help with calculating average, stdev, and other info based on slicer date range by Step and Product.
This should just be a matter of creating a couple of measures
eg.
Avg Data = AVERAGE( Table1[Data] ) Stdev Data = STDEV.P( Table1[Data] )
(note I've just used "table1" as a placeholder for your table name)
By default these should pull in the current context from any slicers.
2 Replies
- d_gosbell
Super User
EZiamslow wrote:I created some process control charts with a slicer on top by date. I need help with calculating average, stdev, and other info based on slicer date range by Step and Product.
This should just be a matter of creating a couple of measures
eg.
Avg Data = AVERAGE( Table1[Data] ) Stdev Data = STDEV.P( Table1[Data] )
(note I've just used "table1" as a placeholder for your table name)
By default these should pull in the current context from any slicers.
- EZiamslow
d_gosbell wrote:
EZiamslow wrote:I created some process control charts with a slicer on top by date. I need help with calculating average, stdev, and other info based on slicer date range by Step and Product.
This should just be a matter of creating a couple of measures
eg.
Avg Data = AVERAGE( Table1[Data] ) Stdev Data = STDEV.P( Table1[Data] )
(note I've just used "table1" as a placeholder for your table name)
By default these should pull in the current context from any slicers.
That should be easy then. I didn't know slicers will filter out the column calculation for me. I'm over-complicating things. haha.
