Hour calculate - Median Time by hours

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?

---