Forum Discussion
Solved
Dax expression for counting total time for Issue type
Hi Folks , I have a table in which I have infomation about Sprint activity. I have column issue type , liked issueand total time for issue . I want to calculate total time for a issue and relate...
Hi, suraj-k-mishra
Try formulas as below:
Column = VAR _t = SUMMARIZE ( FILTER ( 'Table', [Key] = EARLIER ( 'Table'[Key] ) ), [linked key] ) RETURN SUMX ( FILTER ( 'Table', CONTAINSSTRING ( _t, [Key] ) ), 'Table'[spent time(in sec)] ) // For the current row key, filter all related keys in virtual table _t, and then add their valuesTotal time = 'Table'[spent time(in sec)]+'Table'[Column]Best Regards,
Community Support Team _ Eason
v-easonf-msft
Community Support
Community SupportHi, suraj-k-mishra
I did not see any relevant screenshots, can you upload (not paste) your photos again?
It would be great if you can share your sample file (link of cloud storage) and expected result here.
Best Regards,
Community Support Team _ Eason
I want to calculate total time spent for a task + include total time spent with linked task.
for exp task1 have two linked task - task 2 and task3 , so total time for task 1 is 3000+3890+3456.
hope you got it ,
thanks for looking
- v-easonf-msft
Hi, suraj-k-mishra
Try formulas as below:
Column = VAR _t = SUMMARIZE ( FILTER ( 'Table', [Key] = EARLIER ( 'Table'[Key] ) ), [linked key] ) RETURN SUMX ( FILTER ( 'Table', CONTAINSSTRING ( _t, [Key] ) ), 'Table'[spent time(in sec)] ) // For the current row key, filter all related keys in virtual table _t, and then add their valuesTotal time = 'Table'[spent time(in sec)]+'Table'[Column]Best Regards,
Community Support Team _ Eason