Forum Discussion
Calculate Difference between 2 dates based on a Year slicer
So you should just change the year slicer with the column of the Incidents table and change that in the measures, or that's not what you are looking for?
What is still pending would be adding maybe two more columns in the BinSelect table: "number of incidents" and "rate", bacause I understand that the "number of people" would be the same as the "RangeIndex".
Hello,
I made the changes you recommended and it looks like it is placing the employees into buckets, but the buckets don't appear to be adjusting based on the year of the Date of Incident that is selected.
I've also realized that it is including employees that have been termed. Some of the employees were termed before the Year that is selected, so those employees should not be included in the employee counts. I tried to add in some DAX to exclude those employees, but it wasn't working.
Thank you for your help on this.
-Trevor