How to create summerize table to get max id value

Hi Anonymous ,

Thanks ryan_mayu  for the quick reply and solution.  I have another workaround implemented with DAX that I'd like to share:

We can create a table.

Table 4 = 
CALCULATETABLE (
    SUMMARIZE (
        ALL ( 'Table' ),
        [Name],
        [Sample],
        "start date",
            CALCULATE (
                MAX ( 'Table'[Start date] ),
                FILTER (
                    ALLSELECTED ( 'Table' ),
                    'Table'[Name] = MAX ( 'Table'[Name] )
                        && 'Table'[Id]
                            = CALCULATE ( MAX ( 'Table'[Id] ), ALLEXCEPT ( 'Table', 'Table'[Name] ) )
                )
            ),
        "end dat",
            CALCULATE (
                MAX ( 'Table'[End dat] ),
                FILTER (
                    ALLSELECTED ( 'Table' ),
                    'Table'[Name] = MAX ( 'Table'[Name] )
                        && 'Table'[Id]
                            = CALCULATE ( MAX ( 'Table'[Id] ), ALLEXCEPT ( 'Table', 'Table'[Name] ) )
                )
            ),
        "created id",
            CALCULATE (
                MAX ( 'Table'[Created ID] ),
                FILTER (
                    ALLSELECTED ( 'Table' ),
                    'Table'[Name] = MAX ( 'Table'[Name] )
                        && 'Table'[Id]
                            = CALCULATE ( MAX ( 'Table'[Id] ), ALLEXCEPT ( 'Table', 'Table'[Name] ) )
                )
            ),
        "max_id", CALCULATE ( MAX ( 'Table'[Id] ), ALLEXCEPT ( 'Table', 'Table'[Name] ) ),
        "city",
            CALCULATE (
                MAX ( 'Table'[City] ),
                FILTER (
                    ALLSELECTED ( 'Table' ),
                    'Table'[Name] = MAX ( 'Table'[Name] )
                        && 'Table'[Id]
                            = CALCULATE ( MAX ( 'Table'[Id] ), ALLEXCEPT ( 'Table', 'Table'[Name] ) )
                )
            ),
        "unit",
            CALCULATE (
                MAX ( 'Table'[unit] ),
                FILTER (
                    ALLSELECTED ( 'Table' ),
                    'Table'[Name] = MAX ( 'Table'[Name] )
                        && 'Table'[Id]
                            = CALCULATE ( MAX ( 'Table'[Id] ), ALLEXCEPT ( 'Table', 'Table'[Name] ) )
                )
            )
    )
)

Best Regards,

Neeko Tang

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

Hi All Thanks for the solution . I did follow the below solution like