Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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:
Regards,
Xiaoxin Sheng
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:
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |