I need to add value of the multiple column in single row and get the total sum value in the total column
I need to add the columns, mon, tue, wed , thr, fri and get the total value in total coulmn
Suggest any expression
I have used this expression to get total
SUM(Timesheet[Mon])+SUM(Timesheet[Tue])+SUM(Timesheet[Wed])+SUM(Timesheet[Thr])+SUM(Timesheet[Fri])
I Need the total value for each row in the new Virtual column
Any suggestion on this .
Try:
SUM(LIST([Mon], [Tue], [Wed], [Thu], [Fri], [Sat], [Sun]))
1 Like