Forum Discussion

FlowViz's avatar
FlowViz
Helper III
4 years ago
Solved

Help calculating timestamp differences

Hi folks,   I have a table like so:     I'm trying to calculate a couple of things: 1) How would I calculate the total time in each ColumnName for each WorkItemId? For example for WorkIt...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

TheoC's avatar
TheoC
Community Champion
4 years ago

Hi FlowViz 

 

You should be able to use the following:

 

Sum by Category = CALCULATE ( SUM ( 'Table'[Revision] ) , FILTER ( ALLSELECTED ( 'Table' ) , [ColumnName] = MAX ( 'Table'[ColumnName] ) ) )

Please adjust the Table name to your table name.

 

All the best.


Theo 🙂

 

FlowViz's avatar
FlowViz
Helper III
4 years ago

Sorry this did not work:

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    Apologies on that FlowViz . Thank you for letting me know. Have since modified but I am glad that Ashish_Mathur could provide a great solution!