Forum Discussion
Issue status log to status on a day
Here is another attempt. To generate the log separate Calendar table is created with first date and number of dates as parameter. Status table is merged with it and log for each code is generated by code inside. Not sure that's optimal from performance point of view and if I understood all logic of log correctly, but that's first what was in mind.
Please check attached file.
That could be done with Power Query, please see the mockup attached.
Assumptions are
- first date in the log is with zeros (could be corrected)
- status is changed if the number for next date is more than for previous
Thanks for your quick response, in the attached I see that the second table is transferred into the first status log table. But I need the have this the other way around.
I have a status log table and need to transfer it into the number of statusses per day table. Is this also possible with power query?
Here is another attempt. To generate the log separate Calendar table is created with first date and number of dates as parameter. Status table is merged with it and log for each code is generated by code inside. Not sure that's optimal from performance point of view and if I understood all logic of log correctly, but that's first what was in mind.
Please check attached file.
Thanks, this makes sense.
Oops, sorry for misunderstanding. Okay, I'll try
