This is my first post. Apologies in advance for any missteps and the length
I'm trying to calculate the following per month:
I have 5 tables in my data model in Excel 2016 (I have to produce a pivot table with the results):
Eligibility is based on an employee's new hire group value (CustomerGroup[New Hire Group] = Primary) and region (Region[EmployeeRegion] <> "Unassigned").
I have measures to calculate the total number of eligible employees and eligible employees attending by customer group and region, but can't seem to figure out the DAX to add the date filtering to the mix.
Grateful for any help. Thanks!
Data model and relationships
Could you please clarify more details about your measure and expected results because some of the DAX formula relay on your table relationship?
Thanks for the reply, Jimmy. Maybe it will help to clarify if I share the measures I'm struggling with. Apologies if this is more info than you're looking for.
In my ClassroomTraining fact table, I have 3 measures to calculate training attendees who fall into our primary group based on their job title and location who attended the training:
Help needed on measures 2 and 3: Need to add an additional factor to count only the attendees who took the training within 30 days of their hire date. The Customer data table that this fact table is linked to contains a date column that identifies the last date of an employee's 30-day new hire window called End Date First 30.
In my Customer data table, I have 3 measures to calculate the number of employees in our primary group who are eligible to take the training.
Help needed on measures 2 and 3: Need to add factors