Forum Discussion

suraj-k-mishra's avatar
suraj-k-mishra
Regular Visitor
4 years ago
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...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    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 values
    Total time = 'Table'[spent time(in sec)]+'Table'[Column]

    Best Regards,
    Community Support Team _ Eason

suraj-k-mishra's avatar
suraj-k-mishra
Regular Visitor
4 years ago

 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's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

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 values
Total time = 'Table'[spent time(in sec)]+'Table'[Column]

Best Regards,
Community Support Team _ Eason