Forum Discussion
AdministratorI calculate in hours between two different record dates
AdministratorFirst 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
Hi Admin Syndicate_Admin
thank you for your follow up.
RWRWYou can export you model to excel for furthe debugging. But I guess you should have some kind of power bi product license.
- Syndicate_Admin
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
in this case it has to be a measure. A calculated column won't work. I will adjust the code and send it to you
