[FONT="]Hi there,[/FONT]
[FONT="] [/FONT]
[FONT="]I have a dataset that has a Car ID (Unit ID), the time (and date) the driver logged in and the time (and date) the driver logged out. I am trying to calculate the number to unique units logged on during each 15 minute block of time each day and display it in a table with the date down the left side and the 15 minute block across the top. I keep running into memory errors because the data set is huge (millions of rows). The other issue I have is that I can't figure out how to show which date the 15 minute block occured in if the unit was logged in over night (i.e. logged on at 1900hrs on January 1st and logged out at 0700hrs on January 2nd). [/FONT]
[FONT="] [/FONT]
[FONT="]I have a sample data set I've dumped into an Excel spreadsheet:[/FONT]
[FONT="] [/FONT]
[FONT="]https://www.dropbox.com/s/ovt0mtcgov66lk3/Sample Data.xlsx?dl=0[/FONT]
[FONT="] [/FONT]
[FONT="]Any help would be greatly appreciated. I tried this solution but this didn't seem to work:[/FONT]
[FONT="] [/FONT]
[FONT="]https://community.powerbi.com/t5/Desktop/15-Minute-Increments-between-2-Timestamps/m-p/330330[/FONT]
[FONT="] [/FONT]
[FONT="]Thanks,[/FONT]
[FONT="] [/FONT]
[FONT="]I have a dataset that has a Car ID (Unit ID), the time (and date) the driver logged in and the time (and date) the driver logged out. I am trying to calculate the number to unique units logged on during each 15 minute block of time each day and display it in a table with the date down the left side and the 15 minute block across the top. I keep running into memory errors because the data set is huge (millions of rows). The other issue I have is that I can't figure out how to show which date the 15 minute block occured in if the unit was logged in over night (i.e. logged on at 1900hrs on January 1st and logged out at 0700hrs on January 2nd). [/FONT]
[FONT="] [/FONT]
[FONT="]I have a sample data set I've dumped into an Excel spreadsheet:[/FONT]
[FONT="] [/FONT]
[FONT="]https://www.dropbox.com/s/ovt0mtcgov66lk3/Sample Data.xlsx?dl=0[/FONT]
[FONT="] [/FONT]
[FONT="]Any help would be greatly appreciated. I tried this solution but this didn't seem to work:[/FONT]
[FONT="] [/FONT]
[FONT="]https://community.powerbi.com/t5/Desktop/15-Minute-Increments-between-2-Timestamps/m-p/330330[/FONT]
[FONT="] [/FONT]
[FONT="]Thanks,[/FONT]