Life Time between creation date and today (format dd:hh:mm).

FelippeAzevedo7 — Fri, 03 May 2024 16:37:17 GMT

Hello All

I would like to ask for support because I need to create a column to share the ticket lifetime from creation to today().

I know how to do it in Excel but I can't do it in Power BI.

I can share the lifetime in days or in hous, or in minutes, but not the full details: XX days, xx hours, and xx minutes.

I use these formulas in Excel:

1. =INT(end-start)&" days "&TEXT(end-start,"h"" hrs ""m"" mins """)

2. =INT(SUMPRODUCT(ends-starts))&" days "&TEXT(SUMPRODUCT(ends-starts),"h"" hrs ""m"" mins """)

I created these formulas in power bi:

1. Column = INT(rawdata[Life Time (Days)]) &" Days " & INT(MOD(rawdata[Life Time (Days)],INT(rawdata[Life Time (Days)]))*24) & " Hours and " & MINUTE(rawdata[Life Time (Days)]) & " Minutes"

Column 2 =

var vSeconds=[Life time in Seconds]

var vMinutes=int( vSeconds/60)

var vRemainingSeconds=MOD(vSeconds, 60)

var vHours=INT(vMinutes/60)

var vRemainingMinutes=MOD(vMinutes,60)

var vDays=INT(vHours/24)

var vRemainingHours=MOD(vHours,24)

return

vDays&" Days & "&

vRemainingHours&" Hours & "&

vRemainingMinutes&" Minutes & "&

vRemainingSeconds& " Seconds"

But both formulas are showing only the number of the days and not the all details

Many tks for the support.

Re: Life Time between creation date and today (format dd:hh:mm).

lbendlin — Sat, 04 May 2024 00:04:47 GMT

You can use the same approach as in Excel.

var a = End - Start

return INT(a) & " days " & FORMAT(a,"h") & " hours " & format(a,"m") & " minutes"

Re: Life Time between creation date and today (format dd:hh:mm).

FelippeAzevedo7 — Mon, 13 May 2024 11:47:36 GMT

Hello I will do it.

Many tks for the information.

Re: Life Time between creation date and today (format dd:hh:mm).

FelippeAzevedo7 — Fri, 17 May 2024 14:00:43 GMT

Hello

I used your idea and it worked properly. Many tks

topic Re: Life Time between creation date and today (format dd:hh:mm). in DAX Commands and Tips

Life Time between creation date and today (format dd:hh:mm).

Re: Life Time between creation date and today (format dd:hh:mm).

Re: Life Time between creation date and today (format dd:hh:mm).

Re: Life Time between creation date and today (format dd:hh:mm).