undefined

[Lokesh4120]

Could you please help me on how to calculate time range dynamically(days & hours) for more than 4dates using dax.

Say,

1.10/07/2022 7:00PM ticket initiated

2.14/07/2022 2:30PM requested for clarification from initiator

3.15/07/2022 10:00AM responded and given clarification

4.16/07/2022 3:30PM again requested for clarification

5.17/07/2022 4:55PM responded and given clarification

6.18/07/2022 9:10AM ticket closed

Dates may be added if requested for another clarification based on the ticket.We need to calculate total hours/days took to complete the ticket...Thankyou

[Anonymous · Accepted solution]

Hi @Lokesh4120,

Is there any other field to map the ticket id of these records?
If that is the case, you can use the current ticket id to find out the 'first date' and 'last date', then you can simply use datediff function to calculate the difference.

Regards,

Xiaoxin Sheng

[Lokesh4120]

Hi @Anonymous Thank you for the reply.

Will try this and confirm you if it works.

[jaideepnema]

Hi @Lokesh4120 

Can you share a sample dataset to understand your dataset ?

[Lokesh4120]

Hi@jaideepnema,

Thanks for the reply.

I don't have a dataset for this as this is a new requirement.I got a task to think on this requirement.

[Lokesh4120]

@Ashish_Mathur.

@Hariharan_R 

@dm-p .......please help