Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi ,
I have a sample data below :
I need to calculate change in overtime overperiod per staff.
the rate is changing every year.
for the example : I need to findout what andrew gets more overtime paid this month less or more than previous month.
I need to use PowerBi to generate this report but I run into the problem in DAX
how can i create dax that multiply hour with the correct rate per type of overtime and per year? (Exmple : overtime 1 hour should multiply by overtime 1 rate)
I hope someone can help me with this ,
Thank you
User | Count |
---|---|
21 | |
14 | |
11 | |
7 | |
5 |
User | Count |
---|---|
23 | |
23 | |
20 | |
15 | |
10 |