Forum Discussion
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
4 Replies
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-955b73181Thank you so much BiNavPete . This solution worked.
- 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.
