topic Re: undefined in Developer

undefined

Lokesh4120 — Sat, 20 Aug 2022 04:24:30 GMT

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

Re: undefined

Lokesh4120 — Sat, 20 Aug 2022 04:32:13 GMT

@Ashish_Mathur.

@Hariharan_R

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

Re: undefined

jaideepnema — Sat, 20 Aug 2022 07:33:24 GMT

Hi @Lokesh4120

Can you share a sample dataset to understand your dataset ?

Re: undefined

Lokesh4120 — Sat, 20 Aug 2022 10:30:04 GMT

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.

Re: undefined

Anonymous — Tue, 23 Aug 2022 02:17:52 GMT

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

Re: undefined

Lokesh4120 — Tue, 23 Aug 2022 06:33:45 GMT

Hi @Anonymous Thank you for the reply.

Will try this and confirm you if it works.