Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
FinanceKG
New Member

Date of Most Recent Transaction

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

JobTransaction TypeCreated Date/Time
100Invoice5/20/23 1:30 PM
100Quote5/18/23 6:18 PM
100Quote5/18/23 11:06 PM
200Quote5/19/23 3:54 AM
200Invoice5/21/23 8:42 AM
200Quote5/19/23 1:30 PM
300Invoice5/25/23 6:18 PM
300Quote5/19/23 11:06 PM
300Quote5/20/23 3:54 AM

 

Expected Result

JobLast Quote Date/Time
1005/18/23 11:06 PM
2005/19/23 1:30 PM
3005/20/23 3:54 AM
1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

@FinanceKG That should just be:

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Community Champion
Community Champion

@FinanceKG That should just be:

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

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

 

FinanceKG_0-1685040495188.png

 

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. 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.