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 :)
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 :)
Thanks so much! It works!