How do I display a value in minutes:secconds

[vaaacadamsp]

I have written the following DAX but I can't figure out what I follow the Return with to provide the minutes and seconds as (nn:ss). I need the results to go into a column chart. 
code:

Current Weekly Avg =

VAR AvgTime = CALCULATE(AVERAGE(MIM[value_seconds]),

FILTER(MIM,MIM[u_week_number] =

WEEKNUM(TODAY(),2)-1))

VAR MinTotal = AvgTime/60

VAR MinInt = TRUNC(MinTotal)

VAR SecTotal = ROUND((MinTotal - MinInt)*60,0)

RETURN

?? nn:ss ?? (not a string)

Thank you,

Paul Adams

[v-luwang-msft · Accepted solution]

Hi @vaaacadamsp ,

According your provided ,test the below:

Current Weekly Avg = 
VAR AvgTime = CALCULATE(AVERAGE(MIM[value_seconds]),
FILTER(MIM,MIM[u_week_number] =
WEEKNUM(TODAY(),2)-1))
VAR MinTotal = AvgTime/60
VAR MinInt = TRUNC(MinTotal)
VAR SecTotal = ROUND((MinTotal - MinInt)*60,0)
RETURN MinInt& ":" & SecTotal

Did I answer your question? Mark my post as a solution!And if question still not work ,pls share your sample data.

Best Regards

Lucien

[aj1973]

HI @vaaacadamsp 

this could help you