I have a table "Hourly Rates" which has hourly rates for employees with start and end date. This table will track all the hourly rates with start and end dates
I have Tasks table which tracks tasks done by employees and how much time it took them. This table also has task performed date
Rates in Hourly rates are per hour and Duration in Tasks table in minutes.
We already have a relation between Employee Code and all the date columns are formatted. Above example is for illustration only. What I am looking for is the following in PowerBI. It does not matter if we create a custom column or a measure or a new table all together.
It is very obvious that I am looking to calculate COST depending on the date the task was performed and what were the hourly rates when the task was performed.