Division in power bi

[Anonymous]

Can we divide two columns with multiple values in power bi ?? if yes, then please tell.

[v-zhangti]

Hi, @Anonymous 

Is this the result you want?

If not, please also provide more information.

Best Regards,

Community Support Team _Charlotte

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

[danextian]

Hi @Anonymous 

This is how division worksin Power BI.

As a measure:

• DIVIDE ([Aggregate Measure1/number], [Aggregate Measure2/number], <alternate result when division by zero returns an error>)

As a column:

• DIVIDE ([Aggregate Measure1] or a number, [Aggregate Measure2] or a number, <alternate result when division by zero returns an error>)
• DIVIDE ( Table[Column1] or a number, Table[Column2] or a number,<alternate result when division by zero returns an error>)