Good afternoon, I have a table called payroll which has the date of entry and retirement of personnel. I have a measure called "trabajadores activos" which calculates the daily active personnel according to the date of entry and retirement. All okay until I insert the information for the following month since the information is mixed because it is not related to a calendar table because my payroll does not have the daily personnel records. How could I relate my measure "active workers" in the calendar table to have daily records per month or, failing that, how could I generate a summary table with daily records according to my measure?
A possible solution is to generate daily records according to the date of entry and withdrawal, for example if a person entered on 06/01/2021 and stopped on 06/05 2021 to generate:
That would be a possible solution but what happens if you have 5000+ workers in the company and that have been going on for years, it would generate millions of lines and it would not be viable. So I think a solution would be to generate a summary table per day but I don't know how to do it
>>All okay until I insert the information for the following month since the information is mixed because it is not related to a calendar table .
What's your new add-in data's struture? I suggest you to transform the data which is new add-in to the oldest struture instead of to changing your original struture. Would you please show us some sample data for your new add-in data? Then we can help you more accurately.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.