Forum Discussion

aktripathi2506's avatar
aktripathi2506
Icon for Helper IV rankHelper IV
10 years ago
Solved

Calculated column by using group by other columns.

Hi All,   I want to calculate total hour spent by the employee for a day   Please find below the example I have also included the desired column which I am trying to get. With this I want to ca...
Need Help
  • v-micsh-msft's avatar
    v-micsh-msft
    10 years ago

    Hi aktripathi2506,

     

    Please take a try with the formula below when creating the calculated column:

    Result = sumx(

                       filter(

                          'Table 0',

                          And('Table 0'[Name]=earlier('Table 0'[Name]),

                                  'Table 0'[Date]=earlier('Table 0'[Date]))),

                       'Table 0'[Hours spent])

    See my testing result:

    For Users whose total hours is less than 8, take use of slicer.

     

    If any further help needed, please feel free to post back.

     

    Regards

v-micsh-msft's avatar
v-micsh-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Hi aktripathi2506,

 

Please take a try with the formula below when creating the calculated column:

Result = sumx(

                   filter(

                      'Table 0',

                      And('Table 0'[Name]=earlier('Table 0'[Name]),

                              'Table 0'[Date]=earlier('Table 0'[Date]))),

                   'Table 0'[Hours spent])

See my testing result:

For Users whose total hours is less than 8, take use of slicer.

 

If any further help needed, please feel free to post back.

 

Regards