Forum Discussion

dglinka's avatar
dglinka
Regular Visitor
9 years ago

Group within a group

My data:

 

Client Update History 
ProductUpdate Dateto Version
A1/1/20162.1
A2/1/20163.1
A3/1/20163.5
A4/1/20163.6
B2/1/20164.7
B3/1/20164.9
B4/1/20165.1
C2/1/20166.2

 

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

 

ProductClients Current Version
A3.6
B5.1
C6.2

 

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

 

thank you!

Need Help

1 Reply

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

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