How to find max Trans ID.

[#1]

Hi All.

i need to find Max Trans ID of a customer at Max date for this i  did group customer ID and Max Trans date.i got it but how to get Max Trans ID of a customer.

Thanks

[#2]

use in you dimension customer and on expression use max(tran date).

[#3]

Thank Sliva,

I need Max(Trans ID)  and Max(Trans Date) of that customer

[sunny_talwar · Accepted solution]

Like this?

Customer:

LOAD [Customer ID],

    [Tran Date],

    [Trans ID]

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Customer_G:

LOAD [Customer ID],

  Max(Date([Tran Date])) as Max_Trans_Date,

  MaxString([Trans ID]) as Max_Trans_ID

Resident Customer

Group By [Customer ID], [Tran Date];

[#5]

use maxstring(Trans ID)