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 ...
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

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 🙂

 

PaulDBrown's avatar
PaulDBrown
Community Champion
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Dear Paul, 

     

    This helped a lot !

     

    Thx !