Forum Discussion
Attain total hours based on single time column and unique values in other columns
For the sake of closing the post, I was able to solve this problem in a different manner. I was able to get the filter suggested in the post to work for a smaller data set. Once the set grew it would not solve. My guess was that times repeated and it broke the filter. Merging date/times and using this field in teh filter would also not work for some reason on larger data sets.
Using the "Group By" function in power query allowed the creation of two new columns (max time and min time). From there creating a duration/decimal hours was pretty simple.
That section of code looked like this
For the sake of closing the post, I was able to solve this problem in a different manner. I was able to get the filter suggested in the post to work for a smaller data set. Once the set grew it would not solve. My guess was that times repeated and it broke the filter. Merging date/times and using this field in teh filter would also not work for some reason on larger data sets.
Using the "Group By" function in power query allowed the creation of two new columns (max time and min time). From there creating a duration/decimal hours was pretty simple.
That section of code looked like this