cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

## Difference of date and time in the same column but with condition.

Dear: I have reviewed all the posts to look for the solution and I have combined solutions that use MAX, MIN, EARLY etc and do not find the solution, the problem is as follows:

The table consists of 2 columns, INCIDENT_NUMBER is the number of the event, and the FECHA_HORA are the events that were logged with its date and time.

Objective: I need to be able to add up every minute that EVERY RECORD has.

Please if you can guide me to how to do it.

Best regards.

1 ACCEPTED SOLUTION
Resident Rockstar

It's a DAX column

And a measure

``````Measure =
VAR MinDate = MIN(Incident_table[FECHA_HORA])
VAR MaxDate = MAX(Incident_table[FECHA_HORA])
RETURN
DATEDIFF(MinDate,MaxDate,MINUTE)``````
``````Column =
VAR CurInc = Incident_table[INCIDENT_NUMBER]
VAR MinDate = MINX(FILTER(Incident_table,Incident_table[INCIDENT_NUMBER]=CurInc),Incident_table[FECHA_HORA])
VAR MaxDate = MAXX(FILTER(Incident_table,Incident_table[INCIDENT_NUMBER]=CurInc),Incident_table[FECHA_HORA])
RETURN
DATEDIFF(MinDate,MaxDate,MINUTE)``````

5 REPLIES 5
Resident Rockstar

It's a DAX column

And a measure

``````Measure =
VAR MinDate = MIN(Incident_table[FECHA_HORA])
VAR MaxDate = MAX(Incident_table[FECHA_HORA])
RETURN
DATEDIFF(MinDate,MaxDate,MINUTE)``````
``````Column =
VAR CurInc = Incident_table[INCIDENT_NUMBER]
VAR MinDate = MINX(FILTER(Incident_table,Incident_table[INCIDENT_NUMBER]=CurInc),Incident_table[FECHA_HORA])
VAR MaxDate = MAXX(FILTER(Incident_table,Incident_table[INCIDENT_NUMBER]=CurInc),Incident_table[FECHA_HORA])
RETURN
DATEDIFF(MinDate,MaxDate,MINUTE)``````

Thank you very much for your help, there I was able to solve the problem, now if I get the total minutes that INCIDENT_NUMBER and with it I can filter it.

Community Support

Best Regards,
Kelly

Super User

Your request isn't clear enough. Do you want to add just the minutes or the hours and the minutes?

Or do you want to work out the time/duration between the first row and the last (for each Incident Number)?

Can you please supply an example of what you want as the result.

Regards

Phil

If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!

Hello @Syndicate_Admin, what I'm doing is ...... ccontar the DIFFERENCE in minutes of the same INCIDENTS, for example, in the image appears as the first incident the registration INC00002187424 which has several date records and which in total adds up to 324 minutes.

Then I know that INCIDENT_NUMBER, in all the event logs that were made, totaled 324 minutes of duration. That's what I have to do with the other records down.

I hope you understand.

Best regards.