Difference value start month and final month...COVID 19
I have a problem. I have a data table of Covid19. In this table i have | Date | Region | Recovered | Death | Hospitalized | ecc.. The values of the patients are cumulative: for each day I have the total value but no the incremetal value for day.
My goal it's calculate the month trend --> for example for May I would like to calculate the difference of recovered at the end of the month and at the beginning of the month to understand the monthly increase.
I also have the data table I have a master calendar table.
I would like to realize a histogram o another chart..
To complete the discussion, the problem can also be seen in this other way: Having an initial warehouse with inventory at the beginning of the month and one at the end of the month, I want to evaluate the increase / decrease of inventories in the warehouse considering therefore the initial inventory on day 1 of the month and the final inventory on day 31 of the same month. This calculation, for all months