Forum Discussion

dglinka's avatar
dglinka
Regular Visitor
9 years ago

Group within a group

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 ...
Need Help
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] ) )
        )
    )