Division

[Naveeduddin]

Hi Team,

How to divide Colum B by Column A but one step above like shown in below diagram?

Ex: Yellow / Yellow

Green/Green 

Regards

Naveed

[Mahesh0016]

@Naveeduddin 

Divison_AB =

DIVIDE (

    'Table A'[Total A],

    LOOKUPVALUE ( 'Table A'[B], 'Table A'[ID], SELECTEDVALUE ( 'Table A'[ID] ) + 1 )

)

@Naveeduddin Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! THANK YOU!!

[Naveeduddinj]

Hi @Mahesh0016 , This works Thank you.

[BiNavPete · Accepted solution]

Hi @Naveeduddin 

See attached PBIX with PQ and DAX solutions. Link Here.

Both solutions work by creating an index column and looking up index -1.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Happy to help!!

Pete
Web: https://binavigation.com
Linked In: https://www.linkedin.com/in/pete-smith-955b73181

[Naveeduddin]

Thank you so much @BiNavPete . This solution worked.