create a new calculated column by multiply two other columns in the same table

[Anonymous]

Hi,

I'm new to the Power Bi. 

I have a table, one column is Quantity, another column is cost. Now I would like to create a new column as quantity * cost.

When creating this new column, I have tried below, none of them works.

New Column = table1[cost] * table1[Quantity]

New Column = sum(table1[cost]) * sum(table1[Quantity])

New Column = SUMX(Table1, table1[Cost] * table1[Quantity])

Please help!

Thank you

[ShivaniDhoble]

Wants to multiply 2 columns (qty and cost) giving ifs function in another 2 columns 

[MrBorg]

Wow you have tried all the things I would do - Could it be that there is something wrong with our Logic - Not the Power Bi Logic? Since our logic doesn't comply with the typical logic like multiplying two columns in the same row in a new column should be quite simple. But intellisence should then suggest columns I really think Power Bi could be improve with better intellisence or more drag and drop options. Multiplying two columns should not be that difficult and it makes the Power Bi learning Crew (blody poor spell checker) too steab.  

Just a fun thing to try in Power Bi to make it totally Crash - right click a Table and press Copy and then wait it will put in the whole "shiii." in the input field - man this is disappoint . I can now start all over again.

[Icey · Accepted solution]

Hi @Anonymous ,

I created a simple example and it works well.

Try this:

1. Clear cache.

2. Update your Power BI Desktop to the latest version.

If the issue is still there, please share me a dummy PBIX file without real data or sensitive information.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VasTg]

@Anonymous 

That seems weird.

What is the message you get? Are these columns(cost and quantity) in type whole number or Decimal?

If this helps, mark it as a solution.

Kudos are nice too