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
Greg_Deckler
Community Champion
Community ChampionI would create a column in each table that concatenates those three columns. Then you can relate the two tables (not datasets) to one another and then the measure is very simple to create, just SUM([Hours]) * SUM([Revenue]) essentially.