Forum Discussion

Sander_NL's avatar
Sander_NL
Icon for Helper I rankHelper I
5 years ago
Solved

How to extract the highest value

Good morning!,   I've have the following columns in the same table   ID Status Y1000.A04 OK Y1000.A05 NOK Y1000.A06 OK Y2000.A01 OK Y2000.A02 OK ...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    Great start Sander_NL 

     

    There's a few options, one you can try is a new column: 

     

    LatestVersion = IF( COUNTROWS(FILTER('Table', 'Table'[Version] >= EARLIER('Table'[Version]) && 'Table'[Segment] = EARLIER('Table'[Segment])))=1, 1)

     

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago

Great start Sander_NL 

 

There's a few options, one you can try is a new column: 

 

LatestVersion = IF( COUNTROWS(FILTER('Table', 'Table'[Version] >= EARLIER('Table'[Version]) && 'Table'[Segment] = EARLIER('Table'[Segment])))=1, 1)

 

Sander_NL's avatar
Sander_NL
Icon for Helper I rankHelper I
5 years ago

Thanks this solution is working!