Calculate Salary by month using calculated column

[amirabedhiafi]

I have the following calculated column : 

TotalWagePerDay =

IF (

'Time'[DayType]= "Holiday", RELATED(Employees[Hourly Wage]) * [Hours] * 2,

(RELATED(Employees[Hourly Wage]) * [Hours] ) + 1.5 * ([Hours]-8

)

)

I want to calculate the [Salary by month] (as a calculated column using DAX for each employee) to have a matrix like below :

• Table [Time] contains [Date], [Hours], [DayType] and [TotalWagePerDay] columns
• Table [Dates] contains [DayType]
• Table [Employees] contains [Employee] and [Hourly Wage]

@parry2k 

[v-rzhou-msft · Accepted solution]

Hi @amirabedhiafi 

Due to you use "related" function in calculated column, your Table[Time] and Table[Employee] should be related.

I think your Table[Time] contains [employee].

I build a sample to achieve your goal.

Time:

Dates:

MonthName and Month columns are calculated columns.

MonthName = FORMAT(Dates[Date],"MMMM")

Month = MONTH(Dates[Date])

Employees:

Relationship:

Result is as below.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[mhossain]

Hello @amirabedhiafi 

Not able to understand completely though.

When you drag Date (Month) in columns, employee name in rows and SUM(Totalwageperday) in value then what issue you are facing?