The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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 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?
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
17 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
19 | |
10 | |
5 | |
4 | |
3 |