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
Dalton948
Frequent Visitor

First and Last Date Metric Help

Currently trying to delevope a metric to calculate the difference between the first and last date of a specific group of data with the same "element_id" below is what i've been working on, any tips?

Example Table:
Dalton948_1-1680234203631.png

I need the difference between the earliest time and latest time for each group of element ids.

 
FLR = VAR firsttime =
CALCULATE(
VALUES('sys_journal_field'[sys_created_on]),
FILTER(ALLEXCEPT('sys_journal_field','sys_journal_field'[element_id]), FIRSTDATE(sys_journal_field[sys_created_on]))
)

VAR lasttime =
CALCULATE(
VALUES('sys_journal_field'[sys_created_on]),
FILTER(ALLEXCEPT('sys_journal_field','sys_journal_field'[element_id]), LASTDATE(sys_journal_field[sys_created_on]))
)

Return

DATEDIFF(firsttime, lasttime, MINUTE)
1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

Is this what you are looking for?
Screen Capture #773.png

View solution in original post

3 REPLIES 3
Ahmedx
Super User
Super User

Is this what you are looking for?
Screen Capture #773.png

I think that would be it sir. Thank you for your help.

Ashish_Mathur
Super User
Super User

Hi,

You have not mentioned the problem that you are facing.  Anyways, drag element_id to the visual and write this measure

Measure = max(sys_journal_field[sys_created_on])-min(sys_journal_field[sys_created_on])


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.