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

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

 

Michel89's avatar
Michel89
Regular Visitor
8 years ago

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)

  • Anonymous's avatar
    Anonymous
    Not applicable
    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 :)

    • Michel89's avatar
      Michel89
      Regular Visitor
      8 years ago

      Thanks so much! It works!