Is there a measure for last purchase price? I found "Last purchase Date" but i need the cost associated with that transaction.
The reason for not including this measure, is that there is potential for conflicting information - if there are two lines for the same item, at a different price. OR you have several transactions on the same day, each with the same item, but a different price.
If you can live with that possibility, I would visit either the website of Mr. Excel or PowerPivotPro or visit our QQube Certified Solutions Providers page to contract someone to create one for you. https://clearify.com/community/find-an-expert
It is not particularly an easy measure to produce.
Choose a location