The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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...
User | Count |
---|---|
14 | |
12 | |
7 | |
6 | |
5 |
User | Count |
---|---|
28 | |
18 | |
13 | |
7 | |
5 |