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