Forum Discussion
Calculation between two tables
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 :-)
I've tried adding a column to the table 'Werkzaamheden', but got an error:
Expression.Error: The name RELATED hasn't been recognized.
= Table.AddColumn(#"Type gewijzigd", "KostenWerkzaamheden", each Werkzaamheden[Duur] * RELATED(Kosten[Kosten]))
I don't know what I'm doing wrong?
Are you using PowerBI Desktop? Looks like your adding the column in the wrong place (the query editor instead of in the table). Check out this video about how to add a calculated column to a table:
https://www.youtube.com/watch?v=62mLfiNcqVM
Yes, I am using the PowerBI Desktop
I've tried this first, but then I got a notification that no single value for Werkzaamheden[Duur] could be selected.
(Sorry, language is set to Dutch in PowerBI)
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 :)