Forum Discussion
Solved
Timestamping/Creating Copy of Previous Data
I am pulling CRM data from MySql for a Power BI report and the goal is to have a "Speed to Contact" style report on our lead contacts. The data in Sql only stores 4 columns: Unique ID Lead Creati...
BrianaHop
I have added that as well:Time Difference = VAR _CURRENT = CONTRACTS[Status Changed] VAR _PREVIOUS = CALCULATE( MAX(CONTRACTS[Status Changed]), CONTRACTS[Status Changed] < _CURRENT, ALLEXCEPT(CONTRACTS,CONTRACTS[Contract ID]) ) VAR _Time = DATEDIFF(_PREVIOUS,_CURRENT,SECOND) var vSeconds=_Time 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 IF( ISBLANK(_Time),BLANK(), vDays&":"& vRemainingHours&":"& vRemainingMinutes )________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply š
Thank you! Is there any easy way to break down the DateDif to show Days, Hours, Mins? Some of the updates are days later.
BrianaHop
I have added that as well:
Time Difference =
VAR _CURRENT = CONTRACTS[Status Changed]
VAR _PREVIOUS =
CALCULATE(
MAX(CONTRACTS[Status Changed]),
CONTRACTS[Status Changed] < _CURRENT,
ALLEXCEPT(CONTRACTS,CONTRACTS[Contract ID])
)
VAR _Time = DATEDIFF(_PREVIOUS,_CURRENT,SECOND)
var vSeconds=_Time
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
IF( ISBLANK(_Time),BLANK(),
vDays&":"&
vRemainingHours&":"&
vRemainingMinutes
)
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply š