Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi team
Sir @amitchandak
I got issue here , i want to convert Second into x days hh:mm:ss
pls kindly help to define dax to generate those requirement
Thanks
SE
Solved! Go to Solution.
Finally i found my own solution
x Day HH:MMHSS = var vSeconds=[TotSec] 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" |
Thanks Any respond
SE
Finally i found my own solution
x Day HH:MMHSS = var vSeconds=[TotSec] 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" |
Thanks Any respond
SE
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
i required x day x hours x minutes x second in text
Thanks
SE
Please see this article for a good way to calculate and format durations.
Calculate and Format Durations in DAX – Hoosier BI
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks For Insight
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |