Hi All
1) I have a data set from Jan - Sep. It includes a couple of columns and a timesheet column for each employee for each month in each row
2) Each row represents each employee for each month
3) From the slicer, when I choose more than 1 month, under the timesheet column, it shows the summation of hours for the all selected months.
4) Let's say, If I choose July and Sep, under the timesheet column it'll show hours for July + Sep
5) Measure for Missing Timesheet:
Missing Timesheet = ([WorkingHours]-sum(Table[Submitted Hours)]))
Desired:
From slicer, after selecting multiple months, I need the missing timesheet column to show total hours for that month only for each employee in each row.
Pic1: Months selected are April - July. Missing Timesheet showing 648hrs = summation of hours April - July. In contrast, I need to show hours for each month individually.
Pic2: Missing Timesheet hours for April only: (This is when only April is selected from the slicer)
When selecting multiple months from the slicer, like Pic2, I need to show hours for each month for each employee in each row
Any help is highly appreciable, please.
Thanks
1) I have a data set from Jan - Sep. It includes a couple of columns and a timesheet column for each employee for each month in each row
2) Each row represents each employee for each month
3) From the slicer, when I choose more than 1 month, under the timesheet column, it shows the summation of hours for the all selected months.
4) Let's say, If I choose July and Sep, under the timesheet column it'll show hours for July + Sep
5) Measure for Missing Timesheet:
Missing Timesheet = ([WorkingHours]-sum(Table[Submitted Hours)]))
Desired:
From slicer, after selecting multiple months, I need the missing timesheet column to show total hours for that month only for each employee in each row.
Pic1: Months selected are April - July. Missing Timesheet showing 648hrs = summation of hours April - July. In contrast, I need to show hours for each month individually.
Pic2: Missing Timesheet hours for April only: (This is when only April is selected from the slicer)
When selecting multiple months from the slicer, like Pic2, I need to show hours for each month for each employee in each row
Any help is highly appreciable, please.
Thanks