Forum Discussion

thiago0803's avatar
thiago0803
New Member
6 years ago

Subtracting hours from previous column

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?

DAX

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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)