Forum Discussion

georgec96's avatar
georgec96
Icon for Helper II rankHelper II
4 years ago
Solved

Highest value formula

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.

 

8 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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 )
  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi georgec96 
    Please try

    Max PO Age =
CALCULATE (
    MAX ( TableName[PO Age] ),
    ALLEXCEPT ( TableName, TableName[Desctription] )
)
    • georgec96's avatar
      georgec96
      Icon for Helper II rankHelper II
      4 years ago

      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.