Forum Discussion
Calculating fixed salary based on worked days
Hi all, I'm trying to calculate fixed salary of delivery personel. I choosed the person and filtered dates Total number of working days in the month = CALCULATE(COUNTX('courier grafic','...
Hi, Anonymous
I am not sure how your data model looks like, but if I assume you created your date-slicer by using the column from Courier Grafic Table, please try the below measure.
Total number of working days in the month =
VAR currentmonth =
MONTH ( MAX ( 'courier grafic'[date] ) )
RETURN
CALCULATE (
COUNTX ( 'courier grafic', 'courier grafic'[time_beg] ),
FILTER (
ALL ( 'courier grafic'[date] ),
MONTH ( 'courier grafic'[date] ) = currentmonth
)
)Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Share data in a format that can be pasted in an MS Excel file and show the expected result.
Expected Result Example
Attendance Date Attendance Status EmployeeStatus BranchName NetSalary EmpCategory Emp.No ProjectNo Employee No. of Days Daily Salary Per Day
01/01/2023 O Active City Lab 25,000 Management 1220078 GP/0001 Muhammad Shahzaib 18 1388.888889 1388.888889
02/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
03/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
04/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
05/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
06/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
07/01/2023 O Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
08/01/2023 O Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
09/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
10/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
11/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
12/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
13/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
14/01/2023 O Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
15/01/2023 O Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
16/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
17/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
18/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
19/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
20/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
21/01/2023 O Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
22/01/2023 O Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
23/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
24/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
25/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
26/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
27/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
28/01/2023 O Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
29/01/2023 O Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
30/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
31/01/2023 P Active City Lab Management 1220078 GP/0001 Muhammad Shahzaib 1750
01/02/2023 P Active City Lab 35,000 Management 1220078 GP/0001 Muhammad Shahzaib 20 1750 1750