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 and the beginning of the next. I have created a simplicated table to give you an idea: The time of the first order is white since we do not have a previous order to be able to do the calculation. This would be the calculation to make: Current Order Number D420019A = End Date of Previous Order D433953AC - Current Order Start Date D420019ACurrent order number D420019C= End date of previous order D420019A- Start date of current order D420019C Thank you very much for your help

First of all apologize for not having responded before but last week I was involved and did not have time to try the code you had sent me. First of all, thank you very much for the help, try the code and perfect. As for the debug, from what I see here you can't make a console.log and see what the variable is worth at that time or put a breakpoint and ask for the value of a specific variable, right? Anyway, again thank you very much.

Thank you so much. I have created measure called InDateRange that returns me 1 in the event that the records I select in the datepicker meet the condition. InDateRange = WHERE _rangeStart =FIRSTDATE ( 'Calendar'[Date] )WHERE _rangeEnd =LASTDATE ( 'Calendar'[Date] )RETURNIF (SELECTEDVALUE ( Orders[Start_Date] ) >= _rangeStart&& SELECTEDVALUE ( Orders[End_date] ) <= _rangeEnd,1,0) Then I add a filter to the table where I indicate that InDateRange is equal to 1 and return the records that meet the range of selected dates. Until then, the only thing I would lack and that I do not know how to do is to calculate hours with the current dataset and put it in the Time column. Thanks again

Hello again I just tested the code.I have gone line by line returning the value of each variable with a return, when I have come to return the value of the PreviousEnd variable, it returns all the values of the empty column and it is this variable that slows everything down, it takes about 2 minutes to refresh the report. Any suggestions? I hope we can find that.Thank you very much for your help

The same thing continues to happen to me. I need that without the mesasure of INdateRange I keep the records whose time is White, I always mean the first record of the table will be white since it will be the first order depending on the selected dates. With the InRangeDate measurewithout the InRangeDate measureI would need the final solution to come out like thisI hope I have explained, I am waiting Thank you very much for your help

Hi Syndicate_Admin Here is a sample file with the solution https://www.dropbox.com/t/xt1mFlBtHgSNF5UrTime = 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 ) )

I calculate in hours between two different record dates

22 Replies

Syndicate_Admin
Administrator
4 years ago
First of all apologize for not having responded before but last week I was involved and did not have time to try the code you had sent me.

First of all, thank you very much for the help, try the code and perfect.

As for the debug, from what I see here you can't make a console.log and see what the variable is worth at that time or put a breakpoint and ask for the value of a specific variable, right?

Anyway, again thank you very much.
- tamerj1
  Community Champion
  4 years ago
  Hi Admin Syndicate_Admin
  thank you for your follow up.
  RWRW
  You can export you model to excel for furthe debugging. But I guess you should have some kind of power bi product license.
  - Syndicate_Admin
    Administrator
    4 years ago
    Hello again
    
    I have a doubt.
    
    After I have finished I have been asked to add a filter to the report in which the user can select a date range.
    
    Assuming there are 3 records like this table that I previously attached to you:
    
    If the user selects from 1/3/2022 to 1/6/2022 he should give me a single record (Last record of the table) and in the empty time calculation since it is the only record returned.
    
    When I make the selection, visually on the screen I only see a record but with the time calculation of 9.14 in the time field since although visually we do not see it the dataset still has loaded all the records. Would there be any way to refresh the dataset when the date selection is made?
    
    I hope I have explained thanks
    Best regards
tamerj1
Community 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
  Administrator
  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
    Community 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

Forum Discussion

I calculate in hours between two different record dates

22 Replies

Related content

Dynamic Calculation Different Period

Different Calculations

Calculating Differences

Calculating day/time difference

How to add two different calculated columns of two different table