Forum Discussion
Solved
Division
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
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
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!!
Hi Mahesh0016 , This works Thank you.
