Forum Discussion
GroupBY with a constant value
I have a timesheet export that contains columns with the date, acitivity and hours worked: I wrote the following DAX GroupBy formula to group hours per day, which gives the desired result of t...
Anonymous , You can create a new column
Overtime = Sheet1[Hours])-8
or new measure and use that in visual
"Overtime", SUMX(values(Sheet[Date]), Sheet1[Hours])-8)
amitchandak
Super User
Super UserAnonymous , You can create a new column
Overtime = Sheet1[Hours])-8
or new measure and use that in visual
"Overtime", SUMX(values(Sheet[Date]), Sheet1[Hours])-8)