Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI Table - Sum the Numbers

Please find the above table. I am creating a work timesheet report. There are some resources who create multiple tasks for a week time period. In those case i need to sum the planned and actual hours and make it as a single row instead of 3 rows. 

How can i do it ? Please help.

 

  • Anonymous 

    deactivate parameter 'Show itedms with no data" for all table fields values in VISUALIZATION pane and set Sum aggregate for [Actual Hrs] field

1 Reply

  • az38's avatar
    az38
    Community Champion

    Anonymous 

    deactivate parameter 'Show itedms with no data" for all table fields values in VISUALIZATION pane and set Sum aggregate for [Actual Hrs] field