Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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 ?
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...
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 9 | |
| 7 | |
| 6 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 17 | |
| 14 | |
| 13 |