Extract the value inbetween

[gianmarco]

Dear All,

i have the following table:

Doc Name	Value
A	50
A	30
B	50
B	10
B	5

I already know the functions that let me extract the maximum value per Doc Name (MAXX). 
Same for the minimum value (MINX).

Now, is there a function for which I can extract the value inbetween?

The expected result would be:

Doc Name	Value
A	(null) because there is not a value between the maxx and the minx
B	10

Thank you for your help

[Fowmy · Accepted solution]

@gianmarco 

Do you need a new table, a new column, or a measure?

I create a new column as follows:

New Column = 
var __min = CALCULATE( MIN(Table1[Value]) , ALLEXCEPT(Table1,Table1[Doc Name]))
var __max = CALCULATE( MAX(Table1[Value]) , ALLEXCEPT(Table1,Table1[Doc Name]))
return
  IF( NOT Table1[Value] IN ({__min,__max}) , Table1[Value] )

[gianmarco]

Kudos to you, my friend.