Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to Solution.
@FinanceKG That should just be:
MAXX(FILTER( 'Sample Data', [Transaction Type] = "Quote"), [Created Date/Time])
@FinanceKG That should just be:
MAXX(FILTER( 'Sample Data', [Transaction Type] = "Quote"), [Created Date/Time])
Thank you. With that, I get the same date/time for every job, see below. Any ideas?
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.
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |