Forum Discussion

aktripathi2506's avatar
aktripathi2506
Icon for Helper IV rankHelper IV
9 years ago

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.   Name Date Task...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

aktripathi2506

 

Try this 

 

RunningTotal= SumX(
Filter ( YourTable, YourTable[Name] = Earlier ( YourTable[Name]) && YourTable[Date] <= Earlier(YourTable[Date]) ),
YourTable([HoursSpent])
)

 

It should work

 

If this solves your issue please accpet this as a solution and also give KUDOS.

 

Cheers

 

CheenuSing

aktripathi2506's avatar
aktripathi2506
Icon for Helper IV rankHelper IV
9 years ago

Thank you Anonymous and v-ljerr-msft for detailed reply,

 

But with the suggested solution from both of you I have following problem:

 

I am having 2 different table table 1 and table 2 which are connected to each other. and Name and date are coming from two different table.

 

Hours spent and date is from table 1

name is from table 2

 

Anonymous With earlier I am not able to use the other table's column.

v-ljerr-msft I don't know if there is a way to create a new calculated column which takes input from two different tables.

 

Thank.

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    aktripathi2506

    I don't know if there is a way to create a new calculated column which takes input from two different tables.

    Yes, RELATED and RELATEDTABLE functions should work in this scenario. Could you screenshoot the relationship between your tables and post some sample data in your case?

     

    Regards