Forum Discussion
Calculation by using values from two different datasets
Anonymous,
You can create the following columns in your second table.Column = LOOKUPVALUE(Table2[Hours],Table2[Name],Table3[Name],Table2[Year],Table3[Year],Table2[Month],Table3[Month])
revenue = Table3[Charge-out rate]*Table3[Column]
Regards,
Lydia
Hello all,
I am new on PowerBI and I started to work on DAX recently. I have a question regarding a formulation in PowerBI.
I have two datasets as below:
| Name | Year | Month | Hours |
| John Doe | 2018 | August | 20 |
| John Doe | 2018 | September | 15 |
| Name | Year | Month | Charge-out rate |
| John Doe | 2018 | August | £22.00 |
| John Doe | 2018 | September | £20.00 |
What I'm trying to calculate is the monthly revenue of one person, which means that the formula will calculate John Doe's monthly revenue like this:
| Name | Year | Month | Revenue |
| John Doe | 2018 | August | £440.00 |
| John Doe | 2018 | September | £400.00 |
The formula needs to check the "Name", "Year" and "Month" in both datasets and needs the calculate the revenue by multiplying the rate with hours based on the conditions above.
Much appreciated if you could share your thoughts on this.
Thank you and Best regards,
Ugur
See answer in other thread. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
