Group within a group

[dglinka]

My data:

Client Update History
Product	Update Date	to Version
A	1/1/2016	2.1
A	2/1/2016	3.1
A	3/1/2016	3.5
A	4/1/2016	3.6
B	2/1/2016	4.7
B	3/1/2016	4.9
B	4/1/2016	5.1
C	2/1/2016	6.2

I need to extract the latest (or Current) client version like:

Product	Clients Current Version
A	3.6
B	5.1
C	6.2

not sure if I need to use Group By or Summarize with a Max - help please

thank you!

[Vvelarde]

@dglinka

Hello, you can obtain the current version with this :

CurrentVersion =
    IF (
        HASONEVALUE ( Table1[Product] ),
        CALCULATE (
            VALUES ( Table1[to Version] ),
            FILTER ( Table1, Table1[Update Date] = MAX ( Table1[Update Date] ) )
        )
    )