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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Super User
Super User

@FinanceKG That should just be:

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

@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@FinanceKG That should just be:

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

@ 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!:
Mastering Power BI 2nd Edition

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors