Forum Discussion

notski's avatar
notski
Regular Visitor
9 years ago
Solved

Custom column calculation

Hey folks,   I'm fairly new to Power BI so I appreciate all the help I can get :)   I have two tables, one with a sales ledger (Sales) and the other containing product information (Products). Eac...
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    The exact details are going to depend on your data. But, let's say that Sales and Product tables are related on ProductID. You could do something like this:

     

    Column = IF(([Sale Amount]-[Cost Amount])>0,[Sale Amount],RELATED('Products'[Price]))

    Something along those lines.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

The exact details are going to depend on your data. But, let's say that Sales and Product tables are related on ProductID. You could do something like this:

 

Column = IF(([Sale Amount]-[Cost Amount])>0,[Sale Amount],RELATED('Products'[Price]))

Something along those lines.