Extract Maximum value

Hi OscarSuarez10,

You could create column like below by Mcode

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("VY3BCcAwDMR28bsF2+dznVlC91+jJQ0Ff4WE5hSTQ06vYEK15D6m+EJJL7eNsBDDjGOjP2SO4S2Ewzf6Q0Zt9IUwXuxH03yzdlQFrmrHTHj0Y2REWjuC0FrW/QA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [YEAR = _t, #"CUMULATIVE CASHFLOW" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"YEAR", Int64.Type}, {"CUMULATIVE CASHFLOW", Int64.Type}}),
    #"Added Custom" = Table.AddColumn( Table.AddIndexColumn(#"Changed Type", "Index", 1, 1), "Custom group", each Number.RoundUp([Index]/3)),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Index"})
in
    #"Removed Columns"

Then use measure like below

Measure =
VAR maxt =
    MAXX (
        SUMMARIZE (
            'Table (2)',
            'Table (2)'[Custom group],
            "sum", CALCULATE (
                MAX ( 'Table (2)'[CUMULATIVE CASHFLOW] ),
                ALLEXCEPT ( 'Table (2)', 'Table (2)'[Custom group] )
            )
        ),
        [sum]
    )
RETURN
    IF (
        MIN ( 'Table (2)'[CUMULATIVE CASHFLOW] ) = maxt,
        MIN ( 'Table (2)'[YEAR] ),
        ""
    )

Measure 2 =
VAR maxt =
    MAXX (
        SUMMARIZE (
            'Table (2)',
            'Table (2)'[Custom group],
            "sum", CALCULATE (
                MAX ( 'Table (2)'[CUMULATIVE CASHFLOW] ),
                ALLEXCEPT ( 'Table (2)', 'Table (2)'[Custom group] )
            )
        ),
        [sum]
    )
RETURN
    IF ( MIN ( 'Table (2)'[CUMULATIVE CASHFLOW] ) = maxt, maxt, "" )

You could refer to my sample

 

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.