Forum Discussion

Michel89's avatar
Michel89
Regular Visitor
8 years ago
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...
  • Anonymous's avatar
    Anonymous
    8 years ago

    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 :)

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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 :-) 

Michel89's avatar
Michel89
Regular Visitor
8 years ago

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?