Hour calculate - Median Time by hours

[arthurfsantos]

Hello everyone!

I need your help to solve a big problem for me...

In my databse, I'm have the following informations:

A - ID Product
B - INPUT TIME (FORMAT dd/MM/yyyy hh:mm:ss)
C - OUTPUT TIME (FORMAT dd/MM/yyyy hh:mm:ss)
D - STATUS
E - DURATION TIME
F - KEY USER
G - DEALER
H - PRODUCT

In paralel, I'm have a database named "CalendarDax", that I create using the function DAX "CALENDAR".

- I need calculate the total hours of analysis by day by analist
- Calculate the median time (in minutes) of analysis by analist
- Calculate the median time of analysis by day
- My target is 45 minutes per analyse, it's possible show on my graphic this value like constant?

Anyone can help me?

[arthurfsantos]

This is my database

---

@arthurfsantos wrote:

Hello everyone!

I need your help to solve a big problem for me...

In my databse, I'm have the following informations:

A - ID Product
B - INPUT TIME (FORMAT dd/MM/yyyy hh:mm:ss)
C - OUTPUT TIME (FORMAT dd/MM/yyyy hh:mm:ss)
D - STATUS
E - DURATION TIME
F - KEY USER
G - DEALER
H - PRODUCT

In paralel, I'm have a database named "CalendarDax", that I create using the function DAX "CALENDAR".

- I need calculate the total hours of analysis by day by analist
- Calculate the median time (in minutes) of analysis by analist
- Calculate the median time of analysis by day
- My target is 45 minutes per analyse, it's possible show on my graphic this value like constant?

Anyone can help me?

---