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

[Syndicate_Admin]

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.

[Vera_33 · Accepted solution]

Hi @Syndicate_Admin 

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)

[Syndicate_Admin]

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.

[v-kelly-msft]

Hi  @Syndicate_Admin ,

Is your issue solved now?If so,could you pls mark the reply as answered to close it?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[PhilipTreacy]

Hi @Syndicate_Admin  @fgnavarrete 

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

[Syndicate_Admin]

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.