Forum Discussion

sterry's avatar
sterry
New Member
11 years ago
Solved

Product function in calculated column or measure

How do I add a calculated column that simply is the product of the values in two other columns (Qty on Hand X Unit Cost)?  Seems like it should be easy enough to do, but I'm struggling with it...  Thanks in advance.

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    11 years ago

    Load your PBIX, and go to your Data and go to the table where the columns are. Click "New Column" and enter the formula:

     

    Inventory Cost =[Qty on Hand] * [Unit Cost]

     

     

    • andre's avatar
      andre
      Icon for Memorable Member rankMemorable Member
      11 years ago

      Anonymous i am afraid in this particular case your measure calc will not work.  I am not a big fan of calculated columns but in this case, I think that smoupre's solution will work better.

      • Anonymous's avatar
        Anonymous
        Not applicable
        11 years ago

        andre - Whoop, glossed over this one a little to quickly. Yep, you're right. Thanks for pointing this out.

    • sterry's avatar
      sterry
      New Member
      11 years ago

      Perfect.  Thanks.  That's simple enough.  I was convinced that I had to use some type of built in function to do a calculation.  

  • Anonymous's avatar
    Anonymous
    Not applicable
    11 years ago

    you can do this by building up a final measure by utlizing two hidden measures.

     

    Create and Hide these measures

    Measure1 := SUM([Qty on Hand])

    Measure2 := SUM([Unit Cost])

     

    Final measure

    Measure3 := Measure1 * Measure2

    • konstantinos's avatar
      konstantinos
      Icon for Memorable Member rankMemorable Member
      11 years ago

      andre  Anonymous  Instead of calculated column can use Measure:= SUMX( TableName; TableName[Qty on Hand] * TableName[Unit Cost] )  so you can iterate the whole table like a calulated column.