Employee wise Leaves count the occurrence of (Clubbing CompOff leaves with other leave like Pl, SL, CL and WO etc.)

[Pankaj Mishra]

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