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 |
---|---|
130 | |
81 | |
64 | |
57 | |
55 |
User | Count |
---|---|
213 | |
108 | |
86 | |
82 | |
76 |