Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
  • amitchandak's avatar
    amitchandak
    5 years ago

    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)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks, creating a new column worked!