Forum Discussion

Barrie2020's avatar
Barrie2020
Frequent Visitor
6 years ago
Solved

HHMMSS Duration Total

I currently have a column titled PlayedTime which has seconds converted to show as HH:MM:SS - this appears to be ok   I have a quick measure titled TotalPlayedTime which uses this formula:  TotalPl...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Barrie2020 ,

     

    Try use SUMX() function instead SUM().

    https://docs.microsoft.com/en-us/dax/sumx-function-dax.

    sumx(table,[TotalPlayedTime])

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Barrie2020 

 

Try 

Measure = MAX( '1'[PlayedTime] ) - MIN( '1'[PlayedTime] )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn