Payroll Changes monthly

amal_01 — Sat, 21 Sep 2024 12:42:23 GMT

I have created a dax measure to calculate payroll changes monthly
here is

Earning Change Previous Month = VAR SelectedDate = SELECTEDVALUE('PayStatementEarningLineInquiries'[PeriodStartDate]) VAR SelectedYear = YEAR(SelectedDate) VAR SelectedMonth = MONTH(SelectedDate) -- Determine the previous month VAR PreviousMonthStartDate = IF( SelectedMonth = 1, DATE(SelectedYear - 1, 12, 1), DATE(SelectedYear, SelectedMonth - 1, 1) ) VAR PreviousMonthEndDate = IF( SelectedMonth = 1, EOMONTH(DATE(SelectedYear - 1, 12, 1), 0), EOMONTH(DATE(SelectedYear, SelectedMonth - 1, 1), 0) ) -- Determine the current month VAR CurrentMonthStartDate = DATE(SelectedYear, SelectedMonth, 1) VAR CurrentMonthEndDate = EOMONTH(CurrentMonthStartDate, 0) -- Calculate Total Earnings for the Previous Month VAR PreviousMonthEarnings = CALCULATE( [TotalEarning meas], ALLEXCEPT( PayStatementEarningLineInquiries, PayStatementEarningLineInquiries[Worker] ), '(PayStatementHeaders)'[PeriodStartDate] >= PreviousMonthStartDate, '(PayStatementHeaders)'[PeriodStartDate] <= PreviousMonthEndDate ) -- Calculate Total Earnings for the Current Month VAR CurrentMonthEarnings = CALCULATE( [TotalEarning meas], ALLEXCEPT( 'PayStatementEarningLineInquiries', 'PayStatementEarningLineInquiries'[Worker] ), '(PayStatementHeaders)'[PeriodStartDate] >= CurrentMonthStartDate, '(PayStatementHeaders)'[PeriodStartDate] <= CurrentMonthEndDate ) RETURN CurrentMonthEarnings - PreviousMonthEarnings

this measure give me all total changes between month
How can I found :
1 - Total salary of new Employement in current month
2 - Total salary increases for employees between current month and previous month (not new employees)
3- Total salary decreases for employees between current month and previous month (not new employees)

I want each of them on separate measures , can anyone help me ?

Re: Payroll Changes monthly

lbendlin — Sat, 21 Sep 2024 15:55:35 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

topic Payroll Changes monthly in DAX Commands and Tips

Payroll Changes monthly

Re: Payroll Changes monthly