Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
amal_01
Helper I
Helper I

Payroll Changes monthly

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 ?

1 REPLY 1
lbendlin
Super User
Super User

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-...

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/1447...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.