Simple Calculation

[boonebel10]

Hi Everyone, 

I have loaded excel data into power bi and I simply need to re-build this formula using a measure or column. I'm having difficult re-creating this. Anyone able to help?

=((1+K7)*(1+L6))-1

[v-kelly-msft]

Hi @boonebel10 ，

Try this one:

measure= ((1+selectedvalue(k))*(1+selectedvalue(L))-1

If it doesn't work,you can add a screenshot of your data or upload your data to one drive and share the link with us.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[boonebel10]

[v-kelly-msft]

Hi  @boonebel10 ,

Have you tried my method?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[boonebel10]

It did not work. 

[amitchandak]

Can you share some sample data. Geeting last row needs context, so need data to check that. mark me @

Appreciate your Kudos.

[boonebel10]

can I email you. Not sure how to share my data here. It's in excel.