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
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
104 | |
79 | |
71 | |
48 | |
47 |
User | Count |
---|---|
157 | |
89 | |
81 | |
69 | |
67 |