Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

I calculate in hours between two different record dates

Good morning community, I would need the following help. Currently I have different order numbers and in the factory they would need to know the difference in hours between the end of one order a...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Syndicate_Admin 
Here is a sample file with the solution https://www.dropbox.com/t/xt1mFlBtHgSNF5Ur

Time = 
VAR CurrentStart= Orders[Start Date]
VAR PreviousEnd = MAXX ( FILTER ( Orders, Orders[End Date] < CurrentStart ), Orders[End Date] )
VAR TimeDifference = DATEDIFF ( PreviousEnd, CurrentStart, MINUTE )
RETURN
    IF ( NOT ISBLANK ( PreviousEnd ), DIVIDE ( TimeDifference, 60 ) )
  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    4 years ago

    I am new to all this and I would like to know if there is any way to see what gives you back the functions or the value of the variables?

    I mean if you can put interruption points or make a display of the values that are assuming the values.

    Thank you so much

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Syndicate_Admin 
      Not sure if I accurately understand his question but I think the following might be the answer he is looking for