Forum Discussion
Calculated column by using group by other columns.
aktripathi2506 In desktop, go to query editor -> under Transform tab -> click Group BY and as below to get desired result.
Thank 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
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.
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
aktripathi2506 In that case you can leverage GROUPBY and SUMMARIZE functions of DAX.
