Summarize table with lastest data

[eshanpacheriwal]

Hi
I have a table with columns Created Date, Cust ID and WIN/Loss Status. which has multiple records for the same cust id.

How can we summarize this into a new table by crn with the last values created. I tried using summarize with Max. It gives the right date but not the right status value.

[v-chenwuz-msft · Accepted solution]

Hi @eshanpacheriwal ,

You can try this code to do that:

SUMMARIZETable =
SUMMARIZE (
    'Table',
    [Cust ID],
    "lastest date", MAX ( 'Table'[Created date] ),
    "status value", CALCULATE ( MIN ( 'Table'[status value] ), TOPN ( 1, 'Table', [Created date] ) )
)

Best Regards

Community Support Team _ chenwu zhu

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

[tamerj1]

@eshanpacheriwal 
Are you trying to create a calculated table or a table visual? What is the code that you've used so far?