Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
17 | |
8 | |
7 | |
7 | |
6 |
User | Count |
---|---|
23 | |
11 | |
10 | |
9 | |
8 |