Calculating average based in multiple calculated rows with conditions

[Jack_jo]

Hi 

I have this table of charging sessions in different charging outlets.

Charger ID ; Start time ; Stop time ; Session time.

ex:

11078 ; 12-01-2017 10:10:31 ; 12-01-2017 11:17:22 ; 01:06:51

(there are many different Charger IDs)

The last column is a calculated column with "session time = CDR_RAW[START_TIME] - CDR_RAW[STOP_TIME]"

Now i want a extra column that shows the average charge time for one Charger based on the month.

So the charger with the ID 11078 has the average time of all of the sessions in Jan for all the events happening in Jan.

 11078 ; 12-01-2017 10:10:31 ; 12-01-2017 11:17:22 ; 01:06:51 ; (average charging session for 11078 in Jan)

11078 ; 12-02-2017 10:10:31 ; 12-02-2017 11:17:22 ; 01:06:51 ; (average charging session for 11078 in Feb)

I am new in DAX and i hope you can give me a easy sollution.

Hello from Denmark 

[Anonymous · Accepted solution]

Hi @Jack_jo,

Maybe you can try to convert time value to numeric value, then use convert numeric value to calculate the average duration.
After above steps, convert the calculate average value to time.

Sample:

Session(Total Seconds) =HOUR ( [Session time] ) * 3600 + MINUTE ( [Session time] ) * 60  + SECOND ( [Session time] )

Reference:

Aggregating Duration/Time

Regards,

Xiaoxin Sheng