Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Here is the data:

     

    JobPhaseCostTypeSpentCmdtCostNonCmdtCostCurrEstCostBuyOutTotalCmtdCostCurrBuyoutCost
    211037 01-040 .   .  10107239.9118734-28020.40146754.4
    211037 01-040 .   .  2039508.6300039508.63
    211037 01-040 .   .  808578.530008578.53
    211037 01-042 .   .  1023979.6831339-529.52031868.52
    211037 01-042 .   .  207900.410007900.41
    211037 01-042 .   .  801918.380001918.38