Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
@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 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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |