Forum Discussion

gianmarco's avatar
gianmarco
Icon for Helper IV rankHelper IV
5 years ago
Solved

Extract the value inbetween

Dear All,

i have the following table:

Doc NameValue
A50
A30
B50
B10
B5

 

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 NameValue
A(null) because there is not a value between the maxx and the minx
B10

 

Thank you for your help

Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    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] )

     





2 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    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] )