User Profile
andersoncrh
New Member
Joined 2 years ago
User Widgets
Contributions
Dismembering Lines by hour
Hello guys, I have a database kinda like this with thousands of lines Game Name Machine Number Date Starting Time Ending Time RDR2 3 18/03/2024 00:21:07 06:32:33 LOL 1 18/03/2024 16:07:20 16:50:00 And I want to know if there is a way or even if it's viable to use power query editor to transform or create a secondary table dismembering line by line to have the following result Game Name Machine Number Date Starting Time Ending Time RDR2 3 18/03/2024 00:21:07 00:59:59 RDR2 3 18/03/2024 01:00:00 01:59:59 RDR2 3 18/03/2024 02:00:00 02:59:59 RDR2 3 18/03/2024 03:00:00 03:59:59 RDR2 3 18/03/2024 04:00:00 04:59:59 RDR2 3 18/03/2024 05:00:00 05:59:59 RDR2 3 18/03/2024 06:00:00 06:32:33 LOL 1 18/03/2024 16:07:20 16:50:00 The hour columns are General types. In other words, I want to create a new row when the duration time(Ending Time - Starting Time) + Starting Time(just minutes and seconds) is greater than 60 minutes.Solved455Views0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.