Forum Discussion

FlowViz's avatar
FlowViz
Icon for Helper III rankHelper 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
Icon for Community Champion rankCommunity 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
    Icon for Helper III rankHelper III
    4 years ago

    Sorry this did not work:

    • TheoC's avatar
      TheoC
      Icon for Community Champion rankCommunity 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!