Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help with calculated column

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 !

 

Need Help
Tutorial Requests
  • PaulDBrown's avatar
    PaulDBrown
    6 years ago

    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

8 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    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.

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    6 years ago

    Anonymous 

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Sure,

       

      Here you go.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        And here the solution I would want.

         

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