none
Visual to show difference between Revenue and cost RRS feed

  • Question

  • Data table 1            
              Calculated column  
    Person Product Number Job Title Hours Rates Cost  
    Sandra KICK 1 Managing Partner 50 100 5000  
    Priscilla KICK 2 Business Director 25 80 2000  
    Besty KICK 3 Account Director 12.5 60 750  
    Alberta KICK 4 Account Manager 6.25 40 250  
                 
                 
    Data table 2            
                 
    Person Product Number Job Title Revenue KPI      
    Sandra KICK 1 Managing Partner 10000      
    Priscilla KICK 2 Business Director 5000      
    Besty KICK 3 Account Director 2500      
    Alberta KICK 4 Account Manager 1250      

    Hi I am trying to subtract the cost from the revenue above for the two different tables on 1 visual but I am struggling. I tried using the KPI but i doesnt show the difference.

    Monday, April 24, 2017 11:58 AM

Answers

  • Hi Akousa. If you need help on DAX or PBI visuals, the Power BI Community site would be a better place to post your question.

    In terms of using Power Query to do this, you should be able to Merge the two tables, and then insert a column that calculates the difference between revenue and cost (by selecting Revenue and Cost, and then clicking Add Column->Standard->Subtract).

    Ehren

    Friday, April 28, 2017 11:34 PM
    Owner