Forum Discussion
SUM rows
mork, in the Query editor window (Power Query) right click on your query/table and select Duplicate or Reference. This will create another table with the same contents (I would prefer Reference).
In this new query, select "Group by" from the Home toolbar. In the Group by window, Select the Project Name field form the dropdown for Group by section. Enter "Actual Work" in the New column name text field and select the operation as "Sum" and the Column as "TimesheetActualWork". Click OK once done.
This should provide the desired table.
It works but I don't want to use a measure. I want the data in a table in order to add more related columns after. I want to do that either in the power query or using a new table and DAX functions.
mork, in the Query editor window (Power Query) right click on your query/table and select Duplicate or Reference. This will create another table with the same contents (I would prefer Reference).
In this new query, select "Group by" from the Home toolbar. In the Group by window, Select the Project Name field form the dropdown for Group by section. Enter "Actual Work" in the New column name text field and select the operation as "Sum" and the Column as "TimesheetActualWork". Click OK once done.
This should provide the desired table.
Thank you very much! That did the trick. I don't know why I didn't thought of that earlier. I spent the last two hours trying to build the same table with DAX functions.
mork As an alternative you can create a "New Table" (assuming you are using latest DAX versions ) and then enter more calculated column.
SumProjects = ADDCOLUMNS ( SUMMARIZE ( Projects; Projects[Project] ); "Actual Time"; CALCULATE ( SUM ( Projects[Timesheet] ) ) )
