Power BI DAX Time: Duration Aggregation - Summing Time скачать в хорошем качестве

Power BI DAX Time: Duration Aggregation - Summing Time

Here’s an optimized video description for your topic: *Learn how to sum time values in Power BI using DAX! In this tutorial, we demonstrate Chelsie Eiden's time duration measure to calculate total call times, lap times, and more. Master the logic behind converting time values into seconds, summing them up, and converting them back into a readable time format (Days:Hours:Minutes:Seconds). Perfect for summing race times, call durations, or any custom time field.* 🔑 *What You'll Learn:* How to use DAX to calculate total time values Step-by-step breakdown of the "Total Lap 1 Time" measure Converting time into seconds using HOUR, MINUTE, and SECOND Formatting summed time values into Days:Hours:Minutes:Seconds 💡 *DAX Measure:* ```DAX Total Lap 1 Time = VAR TotalSeconds = SUMX( 'Race Time', HOUR('Race Time'[Lap 1 Time]) * 3600 + MINUTE('Race Time'[Lap 1 Time]) * 60 + SECOND('Race Time'[Lap 1 Time]) ) VAR Days = INT(TotalSeconds / (24 * 3600)) VAR Hours = INT(MOD(TotalSeconds - Days * 24 * 3600, 24 * 3600) / 3600) VAR Minutes = INT(MOD(TotalSeconds - Days * 24 * 3600 - Hours * 3600, 3600) / 60) VAR Seconds = MOD(TotalSeconds, 60) RETURN FORMAT(Days, "00") & ":" & FORMAT(Hours, "00") & ":" & FORMAT(Minutes, "00") & ":" & FORMAT(Seconds, "00") ``` 📊 *Enhance your Power BI reports with precise time calculations and insights!* Let me know if you need any further adjustments!