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
aktripathi2506's avatar
aktripathi2506
Icon for Helper IV rankHelper IV
9 years ago

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.

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
9 years ago

aktripathi2506 In that case you can leverage GROUPBY and SUMMARIZE functions of DAX.