Columns

[MKiama]

Hello All, Tried to fine Q&A but cant find it so apologies for posting this here

i have this problem in Power bi, i need to Multiply two columns but i cant figure out how I need The column with numbers to be multiplied by a dynamic value eg create a new column and have maybe duo 195 mulitplied by 1000 so i get 68,000, duo 280 by 2000 to get 560,000 and so on

Please Help!

[v-qiuyu-msft · Accepted solution]

Hi @MKiama,

You need to create a new table and build the relationship with table Estimates based on Payment Plan field. For example, assume sample data below: 

Then create a calculated column below in the new table: 

Column = CALCULATE(COUNT(Table1[Payment Plan]),FILTER('Table1','Table1'[Payment Plan]=EARLIER(Table2[Payment Plan])))*Table2[MultiplyCol]

Best Regards,
Qiuyun Yu 

[Anonymous]

Not sure whether I get your question correctly.

You can create a calculated column will do , as shown below.

New_Column = Count_Measure* Col_numeric

Pls let me know if you want something else.

Thanks
Raj