topic Re: Calculate of average of time using measures in DAX Commands and Tips

Calculate of average of time using measures

Manav-Shah — Thu, 08 Feb 2024 09:48:14 GMT

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 — Thu, 08 Feb 2024 09:57:17 GMT

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

Manav-Shah — Thu, 08 Feb 2024 10:13:34 GMT

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