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...  Th...
  • Greg_Deckler's avatar
    Greg_Deckler
    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]

     

     

  • konstantinos's avatar
    konstantinos
    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.

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
Memorable 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.