Forum Discussion
Calculation by using values from two different datasets
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 Jo...
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
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