Forum Discussion

vani2506's avatar
vani2506
New Member
6 years ago
Solved

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 wa...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    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)

amitchandak's avatar
amitchandak
Super User
6 years ago

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)