RELATEDTABLE + CALCULATE proper usage

[Anonymous]

I have two tables: Customer and Last login. (1 to many relationship)

Last login contains email addresses and their last login timestamp.

What I want is to create a calculated column in Customer table containing the most recent email address logged in for that customer.

I tried this but DAX does not like me and complains.

email = CALCULATE(RELATEDTABLE('Last login'[Email]));'Last login'[Timestamp] = Customer[Last login])

I've already spent 3hours googleing the solution but with no success.

Thanks for usefull advices.

[Zubair_Muhammad]

@Anonymous

Hi

Try this

email =
VAR login = Customer[Last login]
RETURN
    CALCULATE ( MAX ( 'Last login'[Email] ), 'Last login'[Timestamp] = login )

[Anonymous]

Does not work only blanks in entire column

[Zubair_Muhammad]

@Anonymous

By which field are the tables related?

Can you show a snapshot?

[Anonymous]

Customer(ID)

Last login(Customer ID, Email, Timestamp)

[Zubair_Muhammad · Accepted solution]

@Anonymous

Try this

email =
MAXX ( TOPN ( 1, RELATEDTABLE ( LastLogin ), [Time Stamp], DESC ), [Email] )