PUT MAXIMUM VALUE ON EACH ROW PER ID

Hello!

I would like to know how I could put the maximum value per id in each row.

For example, a third column where id 590 has 4 row records with the maximum period

4

4

4

4

and so for the id 600.

Or failing that third column where it is true in the record id 590, period 4. And the others (period: 3,2,1) False.

Best regards!