Forum Discussion
Anonymous
2 years agoNot applicable
Calculating Max values for each group
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 calcu...
- 2 years ago
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" ) - Anonymous2 years ago
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
2 years agoSuper User
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"
)