Forum Discussion
Helper IVCalculated column by using group by other columns.
Community Championaktripathi2506 In desktop, go to query editor -> under Transform tab -> click Group BY and as below to get desired result.
aktripathi2506Thank you ankitpatira,
But I am afraid that I can not try this way, as in actual senario I am using the data from 3 table which are related to each other (by building the relationship).
So name is coming from Table 1, group is coming from table 2 and hour is coming from table 3.
So i was thinking to do it by using a DAX formula. Because with Dax formula I can use these columns from different table by using the related function.
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
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.
- ankitpatira
aktripathi2506 In that case you can leverage GROUPBY and SUMMARIZE functions of DAX.