Forum Discussion
Solved
Live query limitation workaround
I have a table JobDetail which records start and stop times for a job where the jobdetail table is linked to the job table through the JobId. I currently use a measure to sum the total hours spent pe...
Have no idea on what's you data like and what is the execpted output, based on my understanding, for a data as below, to get something as your stated, you can follow the steps.
- Click "Edit queries" and go to the query edit window.
- Right click on the query and duplicate the query.
- Group by the duplicated query and create a column based on the aggregated hours.
- Merge the Original query with the grouped by query.
If you have any question, feel free to let me know.
Have no idea on what's you data like and what is the execpted output, based on my understanding, for a data as below, to get something as your stated, you can follow the steps.
- Click "Edit queries" and go to the query edit window.
- Right click on the query and duplicate the query.
- Group by the duplicated query and create a column based on the aggregated hours.
- Merge the Original query with the grouped by query.
If you have any question, feel free to let me know.
Thanks for that Eric! Thats what I thought I would need to do, revert to M to solve the issue. Although how did you get the totalHourSpent column? That is based of the hour spent column?