Calculate the difference of some filtered row in a new column

[Anonymous]

Hello Community,

I'm stuck with a creation of a formula to calculate the difference between the rangeof some value (2- or 4 row), we talking of a statistic production data.

I find only reference to find range of data, but not for calculate value.

the starting table is an excel file,  elaborated to a matrix table, with Avarage, std. deviation, and this value that must be calculated from Max and Min value of a range of value.

- Every HEAD have 2,3, or 4 sample, it depend of Measure name group .
- I need to find the range from max and min value for each group of measure.

Here the start table listed

Date and Time	HR.	Operator	Line	Name	Head	Smp2	Low Limit	High Limit	Reading
06/08/2020	09:50:00	OPERATORE	D15	Flangia	1	1	5,8	6,25	6,04
06/08/2020	09:50:00	OPERATORE	D15	Flangia	1	2	5,8	6,25	6,08
06/08/2020	09:50:00	OPERATORE	D15	Flangia	1	3	5,8	6,25	6,02
06/08/2020	09:50:00	OPERATORE	D15	Flangia	1	4	5,8	6,25	5,97
06/08/2020	09:50:00	OPERATORE	D15	Flangia	2	1	5,8	6,25	6,01
06/08/2020	09:50:00	OPERATORE	D15	Flangia	2	2	5,8	6,25	6,00
06/08/2020	09:50:00	OPERATORE	D15	Flangia	2	3	5,8	6,25	6,03
06/08/2020	09:50:00	OPERATORE	D15	Flangia	2	4	5,8	6,25	6,04

elaboratin matrix table

PRESS	MEASURE	DATE	HEAD	MIN	+/-	AVG	MAX	DIFF (RANGE)
D15	Flangia	06/08/2020 00:00	1	5,80	0,04	6,03	6,25	X
D15	Flangia	06/08/2020 00:00	2	5,80	0,02	6,02	6,25	X

and the report that I try to realize (TESTA, will be the  RANGE field).

I hope to have add sufficient information, 

thanks in advance...

Alex

----------------------------

EDIT:  

is it correct this formula syntax? it seem give me the correct value.

Max of Misure minus Min of Misure =MAX('OT'[Misure]) - MIN('OT'[Misure])

[Anonymous]

Thanks for your inerest, and other way to formatting the variables.

Kind Regards

[v-yingjl · Accepted solution]

Hi @Anonymous ,

Sorry for replying late. Based on your description and compared with the start table, matrix table and the matrix table which is in the picture, if you just want to calculate the diff between the max value and the min value for fields, the formula you edited in your post is correct.

Here is the sample based on your start table:

LOW = MIN('Table'[Low Limit])
MAX = MAX('Table'[High Limit])
Diff = [MAX] - [LOW]

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.