Highest value formula

[georgec96]

Hi All,

I've got the following dataset. I'm trying to find a formula that would help me keep the oldest PO Age value but a distinct value in the can_clear_backorders column.

As an example the first 2 PO Numbers serve the same purpose however i would like to show only the oldest one (based on PO Age column).

Any help much appreciated.

[tamerj1]

Hi @georgec96 
Please try

Max PO Age =
VAR CurrentPOAge =
    MAX ( TableName[PO Age] )
VAR MaxPOAge =
    CALCULATE (
        MAX ( TableName[PO Age] ),
        ALLEXCEPT ( TableName, TableName[Desctription] )
    )
RETURN
    IF ( CurrentPOAge = MaxPOAge, MaxPOAge )

[georgec96]

Hi @tamerj1 ,

I am getting the following error

[tamerj1]

@georgec96 
the last Table should be  'Table'

[georgec96]

Hi @tamerj1 , sorry to be a pain but this is not giving me the expected result as you can see.

Is there any way I can create maybe a new table that would give me distinct values in the column Description but keep the highest value in the PO Age column?

[tamerj1 · Accepted solution]

@georgec96 
Please create it as a measure (New measure) not a calculated column

[georgec96]

@tamerj1 ,

Perfect! Thanks alot that worked!

[tamerj1]

Hi @georgec96 
Please try

Max PO Age =
CALCULATE (
    MAX ( TableName[PO Age] ),
    ALLEXCEPT ( TableName, TableName[Desctription] )
)

[georgec96]

Hi @tamerj1 ,

Any idea how can i make the table visual not to duplicate the values?

It's still showing the same as before after applying formula you provided.