cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Service Metrics Analysis

Hi, 

 

I am new to Power BI. 

 

I want to create a new power BI Service report 

 

I want to calculate when the Technician first attended the site and when did they finish his/her job. Also I want to add more calulcations based on this data like Number of Days to Finish the job, Avg Days to Finish the Job etc. 

 

I used to create a Pivot table in excel and run some calculations in excel. Not sure if there is any DAX Formula in Power BI that can simplify this task. 

 

Call No.Attended DateFinished DateCall TypeCentreEng. StatusReqd Date   
5779120-Mar-1720-Mar-17WL1280F15-Jan-15   
5779123-Aug-1723-Aug-17WL1980F15-Jan-15   
9202510-Mar-1731-Mar-17WM1280F5-Jul-16   
9350020-Jan-1720-Jan-17CC1380F20-Jan-17   
9474331-Jan-1721-Feb-17LP1280F22-Aug-16   
9474321-Feb-1721-Feb-17LP1280F22-Aug-16   
970789-Jan-172-Feb-17CC1380F9-Jan-17   
9707810-Feb-1710-Feb-17CC1380F9-Jan-17   
9719917-Jan-1717-Jan-17CH1880F4-Oct-16   
9728421-Apr-1721-Apr-17LP1780F5-Oct-16   
          
Expected Output        
          
Call No.Attended DateFinished DateCall TypeCentreEng. StatusReqd DateMin of Attended DateMax of Finished Date# of Days
5779120-Mar-1720-Mar-17WL1280F15-Jan-1520-Mar-1723-Aug-17156
9202510-Mar-1731-Mar-17WM1280F5-Jul-1610-Mar-1731-Mar-1721
9350020-Jan-1720-Jan-17CC1380F20-Jan-1720-Jan-1720-Jan-170
9474331-Jan-1721-Feb-17LP1280F22-Aug-1631-Jan-1721-Feb-1721
970789-Jan-172-Feb-17CC1380F9-Jan-179-Jan-1710-Feb-1732
9719917-Jan-1717-Jan-17CH1880F4-Oct-1617-Jan-1717-Jan-170
9728421-Apr-1721-Apr-17LP1780F5-Oct-1621-Apr-1721-Apr-170

 

 

Thanks in advance. 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

@vani2506 ,

 

Try like

Min Attended Date = min(Table[Attended Date])
Max Finished Date= Max(Table[Finished Date])

Days Diff = datediff([Min Attended Date],[Max Finished Date],Day)



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

1 REPLY 1
Highlighted
Super User IV
Super User IV

@vani2506 ,

 

Try like

Min Attended Date = min(Table[Attended Date])
Max Finished Date= Max(Table[Finished Date])

Days Diff = datediff([Min Attended Date],[Max Finished Date],Day)



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors