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
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
Thank you so much BiNavPete . This solution worked.