topic DAX for percentage attendance in powerbi in DAX Commands and Tips

DAX for percentage attendance in powerbi

MEHUL123 — Mon, 24 Mar 2025 09:45:01 GMT

Hi,

I have 2 tables,

1) Datetable (having date, months, years)

2) Employee roll wise and date wise attendance

I want to display %Attendance of each employee in output

i.e. -- ideal work days (day count in excluding sunday on any specific month or combination of multiple months) vs actual worked days of any employee for that specific period

Let Say,

EMP_ID	TOTAL work days of specific months	Actual Worked Days of employee on those months	%Attendance
123	26	20	77%
345	26	21	81%
567	26	25	96%
789	26	27	104%
TOTAL	26	23.25	89%

However when i select multiple months (let say selection of Jan25 and Feb25 in filter), than i want sum of 2 month's work days,

means [26 work days (jan25) + 24 work days (feb25)] = 50 work days total...

pls guide, thanks in advance.

Re: DAX for percentage attendance in powerbi

AnkitKukreja — Mon, 24 Mar 2025 12:02:27 GMT

Hi! MEHUL123

I think you are looking for this, if this doesn't help please do share a sample file.
https://www.youtube.com/watch?v=k0I-khGGXE4

Re: DAX for percentage attendance in powerbi

rohit1991 — Tue, 22 Jul 2025 08:17:24 GMT

Hi MEHUL123

You can calculate dynamic percentage attendance by comparing the actual worked days (excluding Sundays) against the total possible working days.

Step 1: Measure for Total Working Days (excluding Sundays)

TotalWorkingDays = CALCULATE( COUNTROWS(DateTable), DateTable[DayName] <> "Sunday" )

Step 2: Measure for Actual Worked Days (per employee)

ActualWorkedDays = CALCULATE( COUNTROWS(AttendanceTable), AttendanceTable[Status] = "Present" -- or whatever status indicates attendance )

Step 3: Measure for % Attendance

% Attendance = DIVIDE([ActualWorkedDays], [TotalWorkingDays], 0)

Make sure your DateTable is marked as a Date table and is properly related to the AttendanceTable on the date column. This setup will give you accurate, dynamic attendance percentages across any time period you slice by including combinations of months, quarters, or years.

Re: DAX for percentage attendance in powerbi

v-hashadapu — Sat, 29 Mar 2025 10:11:46 GMT

Hi MEHUL123 , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

Re: DAX for percentage attendance in powerbi

v-hashadapu — Mon, 07 Apr 2025 09:56:07 GMT

Hi @MEHUL123 , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

Re: DAX for percentage attendance in powerbi

v-hashadapu — Thu, 10 Apr 2025 11:35:03 GMT