Calculate of average of time using measures

[Manav-Shah]

Hi,

I have two data sheets in excel,
First sheet is below 

and second data sheet 

These two data sheet I have in excel and I have to convert below data calculation in Power BI from these two data sheet.

[FreemanZ]

hi @Manav-Shah ,

could you explain how to get the average time? for example, 90:25 for Jay.

[Manav-Shah]

Hi @FreemanZ ,

I get average time for Jay using averageifs function in Excel, but I need this same thing in Power BI.