Convert decimal to minutes and seconds using DAX

Question

I have a column that consist values in seconds, I would like to create a visual which displays minutes and seconds. How do I create a measure that shows the decimal in proper seconds.

Or is it better to do this with M language in Power Query?

Answer 1

Use this calculated column

Minutes & Seconds = 
VAR minutes = 
    QUOTIENT('Table'[Seconds], 60)
VAR seconds = 
    MOD('Table'[Seconds], 60)
RETURN
   FORMAT(minutes, "0#") & ":" & FORMAT(seconds, "0#")