To achieve your requirement, you can try this calculated column:
Price Ranking =
FILTER ( 'Rank', 'Rank'[Product] = EARLIER ( 'Rank'[Product] ) ),
View solution in original post
This works perfectly, thanks! What does the EARLIER function do in this context?
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!