Forum Discussion

Helper 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 ...

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)

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

Helper I

5 years ago

Thanks this solution is working!