Date of Most Recent Transaction

[FinanceKG]

Hello, can someone please help me with a measure for the below situation? I am trying to create a measure that will show the most recent created date/time by Job for only the Quote transaction types.

Sample Data

Job	Transaction Type	Created Date/Time
100	Invoice	5/20/23 1:30 PM
100	Quote	5/18/23 6:18 PM
100	Quote	5/18/23 11:06 PM
200	Quote	5/19/23 3:54 AM
200	Invoice	5/21/23 8:42 AM
200	Quote	5/19/23 1:30 PM
300	Invoice	5/25/23 6:18 PM
300	Quote	5/19/23 11:06 PM
300	Quote	5/20/23 3:54 AM

Expected Result

Job	Last Quote Date/Time
100	5/18/23 11:06 PM
200	5/19/23 1:30 PM
300	5/20/23 3:54 AM

[Greg_Deckler · Accepted solution]

@FinanceKG That should just be:

MAXX(FILTER( 'Sample Data', [Transaction Type] = "Quote"), [Created Date/Time])

[FinanceKG]

Thank you. With that, I get the same date/time for every job, see below. Any ideas?

[tamerj1]

Hi @FinanceKG 

@Greg_Deckler's proposed solution is correct and should definitely work but it seems that the job column that you are placing in the rows of tge matrix is coming from a different (and probably unrelated) table. Make sure yiu are using the column from the same table or from a dimension table that filtets this table.