Multiply a column to multiple column

[Anonymous]

Hi, if i would like to multiple a column to multiple column, like  multiple Column A to Column B and Column F, what should the query be? If it is possible, it is better to do it in one step without making new columns. Thanks. 

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

You can consider to use below measure if it works:

Measure=
sum(Table[ColumnA])*sum(Table[ColumnB])*sum(Table[ColumnF])

If above not help, please share some sample data with expect result to help us clarify your requirement.

Regards,

Xiaoxin Sheng

[Nishantjain]

Can you provide more detial about your question. I am not clear