Forum Discussion
Grouped sum based on each phase field - Direct Query
Hello! I've been stuck on this problem for a while now so thought I would reach out. I am using a Direct Query method so I am not able to use grouping in a power query to accomplish this. Each ph...
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.
Here is the data:
| Job | Phase | CostType | SpentCmdtCost | NonCmdtCost | CurrEstCost | BuyOut | TotalCmtdCost | CurrBuyoutCost |
| 211037 | 01-040 . . | 1 | 0 | 107239.9 | 118734 | -28020.4 | 0 | 146754.4 |
| 211037 | 01-040 . . | 2 | 0 | 39508.63 | 0 | 0 | 0 | 39508.63 |
| 211037 | 01-040 . . | 8 | 0 | 8578.53 | 0 | 0 | 0 | 8578.53 |
| 211037 | 01-042 . . | 1 | 0 | 23979.68 | 31339 | -529.52 | 0 | 31868.52 |
| 211037 | 01-042 . . | 2 | 0 | 7900.41 | 0 | 0 | 0 | 7900.41 |
| 211037 | 01-042 . . | 8 | 0 | 1918.38 | 0 | 0 | 0 | 1918.38 |