Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Power BI Calculations - HELP

Each of the red numbers are assigned to a specific supplier, the blue numbers are the target mix for the different suppliers. I need to subtract these values based on the supplier name. I have a large set of data and they are grouped by month and supplier.

 

Essentially I need to do:

31%-39%
22%-23%

48%-38%

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi @tholland

    If you have a one-to-one relationship between the two tables you can just subtract them. If it is a one-to-many or many-to-many relationship then it is more difficult, please provide some sample data so that I can test it.

    Best Regards,
    Dino Tao

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      2 years ago

      It is not that I need to subtract every value though. I need to subtract certain suppliers (red) from their target mix (blue).