GENERATE ACTIVE PERSONAL DAILY RECORDS
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: 06/01/2021 06/02/2021 06/03/2021 06/04/2021 06/05/2021 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
