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 There,
I’m pretty new in Power Bi and I’m trying to calculate the duration and days from a single start time.
For example the start time is: 11-5-2017 09:48:56
Finally I would like to get a table like this.
Mtime | PowerW | Duration | Days |
11-5-2017 09:48:55 | 2300 | -00:00:01 | 0 |
11-5-2017 09:48:56 | 2300 | 00:00:00 | 1 |
11-5-2017 09:48:57 | 0 | 00:00:01 | 1 |
…. |
|
|
|
13-5-2017 09:48:57 | 2300 | 00:00:01 | 3 |
I hope someone can explain me how to make this.
Solved! Go to Solution.
Hi @JeroenItho,
Try to add two columns:
Time = MIN('Start'[StartTime])-'Power'[Mtime] Format this as a time measure days = IF ( MIN ( 'Start'[StartTime] ) > 'Power'[Mtime], 0, DATEDIFF ( MIN ( 'Start'[StartTime] ), 'Power'[Mtime], DAY ) + 1 )
This should work.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @JeroenItho,
Try to add two columns:
Time = MIN('Start'[StartTime])-'Power'[Mtime] Format this as a time measure days = IF ( MIN ( 'Start'[StartTime] ) > 'Power'[Mtime], 0, DATEDIFF ( MIN ( 'Start'[StartTime] ), 'Power'[Mtime], DAY ) + 1 )
This should work.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |