Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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"
2.
But both formulas are showing only the number of the days and not the all details
Many tks for the support.
Solved! Go to Solution.
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"
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"
Hello
I used your idea and it worked properly. Many tks
Hello I will do it.
Many tks for the information.
User | Count |
---|---|
21 | |
19 | |
12 | |
10 | |
9 |
User | Count |
---|---|
30 | |
25 | |
15 | |
13 | |
10 |