Subtracting hours from previous column

[thiago0803]

Hi guys!!

Hope you can help me...

I have this table that gives me the doc number, start and end day of a certain verification and also the start and finish HOUR.

What I basically need is to calculate the DELAY TO BEGIN, which can be calculated by subtracting for example the D3-E2 or D4-E3 for each DOC NUM(column A) and store this difference in F column.

The day can be different too, for example: Start day can be 5/Jun and finish day can be 6/Jun, what can add more 24 hours diff in column F.

 

Can anyone help me pls?

[harshnathani]

Hi @thiago0803 ,

Incase you want a measure.

Time Difference (seconds) =

var a = MAX('Table'[Start Hour])

var b = CALCULATE(MIN('Table'[Start Hour]),FILTER(ALL('Table'), 'Table'[Start Hour] > a))

RETURN

DATEDIFF(MAX('Table'[Finish Hour]),b,SECOND)

 Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[harshnathani]

Hi @thiago0803 ,

Check this blog.

https://community.powerbi.com/t5/Community-Blog/Getting-Previous-Values-in-Power-BI-Part-1/ba-p/1143...

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)