Convert Excel Formula

[thedeadzeds]

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))

 

[C Moore]

It should write just like you have it. What error are you getting?

 

[thedeadzeds]

Thanks for the reply. So as a column it works fine using the below, but i was wondering how i do this as a mesaure:

NC Column = Audi_Values[NCDIncentives]/(Audi_Values[NCDVehicleWithoutVAT]+(Audi_Values[NCDFactoryOptions]/1.2))

 

[C Moore]

You'd have to wrap everything in a sum or something. It depends on what you ultimately want to display. I've found I use tables most of the time rather than cards, and the totals tend to be wrong on tables with measures.
SUM( Audi_Values[NCDIncentives])/(SUM(Audi_Values[NCDVehicleWithoutVAT])+SUM(Audi_Values[NCDFactoryOptions])/1.2)