Pankaj Mishra
New Member
Hi Team,
I am working on Power BI on this task:
I need the output Employee wise Leaves count the occurrence of (Clubbing CompOff leaves with other leave like Pl, SL, CL and WO etc.)
CO (2 Leaves)+PL (2 Leaves),-------1 occurrence
CO (1Leaves+SL 4 Leaves), --------1 occurrence
CO (4 Leaves+CL 3 Leaves) and----1 occurrence
WO (2 Weekly off)+CO (5 leaves)+WO (2 Weekly off) etc.-------1 occurrence
Out put:
Emp
Emp1 CO+PL (3 count)
Emp 2 CO+SL (2 count)
Emp 3 WO+CO (5 count)
Regards,
Pankaj Mishra
I am working on Power BI on this task:
I need the output Employee wise Leaves count the occurrence of (Clubbing CompOff leaves with other leave like Pl, SL, CL and WO etc.)
CO (2 Leaves)+PL (2 Leaves),-------1 occurrence
CO (1Leaves+SL 4 Leaves), --------1 occurrence
CO (4 Leaves+CL 3 Leaves) and----1 occurrence
WO (2 Weekly off)+CO (5 leaves)+WO (2 Weekly off) etc.-------1 occurrence
Out put:
Emp
Emp1 CO+PL (3 count)
Emp 2 CO+SL (2 count)
Emp 3 WO+CO (5 count)
Regards,
Pankaj Mishra