Help with calculated column

[Anonymous]

Hi,

I have the following situation. 3 Tables (workhours, sales & revenue).

1st question.

By visual element TABLE, I want to show the construction name + Workhours + Materials+ Revenue. This works fine.

I want an extra calculated column (profit/loss) that calculates the amount in column Revenue minus amount workhours minus the Materials.

How is this done? I'm not getting any further with this.

Thanks in advance !

[PaulDBrown]

@Anonymous 

Just to make sure, can you post a screenshot of your model (to check relationships between tables)?

[Anonymous]

Sure,

Here you go.

[Anonymous]

And here the solution I would want.

A green color with profit and a red color with losses would be awesome 🙂

[PaulDBrown · Accepted solution]

@Anonymous 

Thanks for posting a sample PBIX...

Here is the solution I propose.

First the model structure

and the result:

I'm attaching the PBIX file for your reference

[Anonymous]

Dear Paul, 

This helped a lot !

Thx !

[parry2k]

@Anonymous not sure your column name on the screen shot are the same but it should be simple calculation , add new column with following expression

Profit and Lost = 
Table[Column1] + Table[Column2] - Table[Column3] 

change the logic and column/table name in calculation as per your need.

[Anonymous]

Hi,

Thx for the reply, it shows me 3 options (calculatetable, datetable and relatedtable). Which option to chose from?

[Anonymous]

For reference, i've included my test file with 3 tables (workhours, materials, sales). 

https://www.dropbox.com/s/k2p772kkw85vreh/test1.pbix?dl=0