Calculating Max values for each group

[Anonymous]

Hello,

I have a data set similar to the table below that contains the first two columns "ProductName" and "ProductVersion". Currently the third column "LatestVersion" is blank.

How can I calculate the values on the third column so that it I can flag the Max values for each different "ProductName"?

Thanks in advance

ProductName	ProductVersion	LatestVersion
Alpha	1.22.5	No
Alpha	2.0.1	No
Alpha	2.0.15	Yes
Bravo	21.1.0	No
Bravo	22.0.3	No
Bravo	22.1.3	No
Bravo	22.1.14	Yes
Charlie	5.13.3	Yes
Charlie	4.13.3	No
Charlie	3.13.3	No

[Fowmy · Accepted solution]

@Anonymous 

Using this as a calculated column in your table:

Latest Ver = 
IF(
    CALCULATE(
        MAX(Table02[ProductVersion]),
        ALLEXCEPT( Table02 , Table02[ProductName] )
    ) = Table02[ProductVersion],
    "Yes",
    "No"
)

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can create two calculated columns as below to get it, please find the details in the attachment.

PVersion = VALUE ( SUBSTITUTE ( [ProductVersion], ".", "" ) )

LatestVersion =
IF (
    [PVersion]
        = CALCULATE (
            MAX ( [PVersion] ),
            FILTER (
                ALL ( 'Table' ),
                'Table'[ProductName] = EARLIER ( 'Table'[ProductName] )
            )
        ),
    "Yes",
    "No"
)

Best Regards

[Fowmy · Accepted solution]

@Anonymous 

Using this as a calculated column in your table:

Latest Ver = 
IF(
    CALCULATE(
        MAX(Table02[ProductVersion]),
        ALLEXCEPT( Table02 , Table02[ProductName] )
    ) = Table02[ProductVersion],
    "Yes",
    "No"
)