How to get MAX date from two records to one record

[chandraismoon]

Hi All,

I have a data set Having same values except date column

Ex:

ID                   changed date             category

1                     1/3/2020                     Bike

1                      3/3/2020                    Bike

2                     3/3/2020                     car

2                      4/3/2020                    car

In this I want the out put as 

ID                   changed date             category

1                      3/3/2020                    Bike

2                      4/3/2020                    car

How can I achieve it 

Please help

[v-lionel-msft · Accepted solution]

Hi @chandraismoon ,

Try to create a measure for date column:

Max_date = 
CALCULATE(
    MAX([changed date]),
    ALLEXCEPT(
        'Sheet1 (2)',
        'Sheet1 (2)'[ID], 'Sheet1 (2)'[category]
    )
) 

Finally, you can change the data format

Best regards,
Lionel Chen

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

[niteshtrehan89]

Hi chandraismoon,

We can write the DAX function to get the max date by grouping the categories.

test = CALCULATE(MAX(Test[Changed Date]),GROUPBY(Test,Test[Category]))