Convert Excel forum in power bi

[craigmon]

Hi Guys,

Is there a way to recreate this excel formula in power bi.  The brackets are key in this formula.

Thanks

AN2 = Incentives

P2 =  VAT

R = Factory

=AN2/(P2+(R2/1.2))

[v-xiaotang · Accepted solution]

Hi @craigmon 

if you want to recreate it by MEASURE:

Measure = DIVIDE(MIN('Table'[AN2 ]),MIN('Table'[P2])+DIVIDE(MIN('Table'[R2]),1.2))

 or if you want to recreate it by COLUMN:

Column = DIVIDE('Table'[AN2 ],'Table'[P2]+DIVIDE('Table'[R2],1.2))

Best Regards,

Community Support Team _ Tang

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

[craigmon]

Thank you so much