Forum Discussion

craigmon's avatar
craigmon
Icon for Helper I rankHelper I
5 years ago
Solved

Convert Excel forum in power bi

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))      
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    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.

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
5 years ago

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's avatar
    craigmon
    Icon for Helper I rankHelper I
    5 years ago

    Thank you so much