Forum Discussion
Solved
Calculation between two tables
Hello everybody, I'm new to PowerBI and have a question about creating a query / formula that can calculate a value from cells of different tables. I have a table called 'Werkzaamheden' and a t...
I think you are trying to create a MEASURE (meetwaarde), you should create a COLUMN (kolom). Add the column to the [Werkzaamheden] table and not the [Kosten] table. I just tried and it worked :)
As jthomso mentioned, If you create a link between the two Functie columns, you can add a calculated column to the Werkzaamheden table:
KostenWerkzaamheden = Werkzaamheden[Duur] * RELATED(Kosten[Kosten])
That one should work :-)