Chart Display for Non-OT and OT values

[winniexlee]

Hi Experts,

I have this table that has 3 columns:

1. Normal Hours

2. OT Hours

3. Employee Name

I would need to calculate segregate the hours to display in the chart. How do i display both values of the normal hours and OT hours in the chart? On top of that, I would need another table to indicate if the OT hours is payable at 1.5x or 2x of their salary, with 1.5x being normal days overtime and 2x being public holiday or Sundays. 

I would also need to state the percentage and show the trend of the overtime as compared to the normal working hours. 

[winniexlee]

Hi @amitchandak,

My current table looks like this:

Emp No	Job	Start Date	End Date	Normal Working Hrs	OT Hrs
Dave	Painting	3-Jan	3-Jan	8	3
Bob	Assembly	4-Jan	4-Jan	10	0
Jack	Maintenance	5-Jan	5-Jan	8	6

On top of that, i have another table indicating the date for public holidays. Other than showing the normal working hours, OT hours, the trend of the OT hours in %, i would still need to limit my data according to:

1. Employees cannot work more than 12 hrs of overtime a day

2. Employees cannot exceed 44 hours OT in three weeks

3. Employees cannot work consecutively for 19 days (including PH and weekends)

4. Overtime a month cannot exceed 72 hrs (excluding PH and Sundays)

I would then need to visualize the above in a separate chart.

[amitchandak]

@winniexlee , You need measures like

Sum(Table[Normal Hours])

Sum(Table[OT Hours])

OT Pay = SumX(Table,   Switch(True() ,

Employee[Type]="A", [OT Hours] *2.5,

[OT Hours] *1.5

) * [Hourly Pay])

Ratio = divide(Sum(Table[OT Hours]) , Sum(Table[Normal Hours]) )

Change as per need

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.