Product function in calculated column or measure

[sterry]

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.

[Greg_Deckler · Accepted solution]

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]

[Greg_Deckler · Accepted solution]

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]

[sterry]

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

[andre]

@Seth_C_Bauer 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.

[Seth_C_Bauer]

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

[Seth_C_Bauer]

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 · Accepted solution]

@andre  @Seth_C_Bauer  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.