Forum Discussion
Dynamic Status for pragmatic report
I currently have 2 data sets List if employees with training date and employee ID List of work done with date of work done and employee ID (Note: single employee has done multiple jobs in one d...
the only way i can think of doing this is by merging a list of employees to a generic list of dates.
so if i had 365 days and 100 employees i would expect to have a table containing 36500 rows from here i can assign a 'Active' 'Inactive' custom column on a daily basis and then count unique in powerBi to condense into a monthly graph however this does not represent the cummulative increase in staff over the same period as staff trained in November would show as inactive in October but this is not the case
please help