DAX Measure for Each Month Calculation

rkrt1

New Member
Joined
Jul 24, 2022
Messages
19
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
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.
1663630351669.png


Pic2: Missing Timesheet hours for April only: (This is when only April is selected from the slicer)
1663630505836.png

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 :)
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Forum statistics

Threads
1,215,491
Messages
6,125,101
Members
449,205
Latest member
ralemanygarcia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top