Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
PDRTXRA
Helper I
Helper I

Best Product per Client

Hello.

I have two tables. One with clients. One with sales.

I want to create 3 columns in my clients table.

 

First column: Name of the product in which they spent the most money.

Second column: Name of the product in second place.

Third column: Name of the product in third place.

 

To clarify: I need the results to show the product in which the client spent the most money overall. So, for example, if a client spent 20€ on boots  and 50€ on 10 t-shirts, it should say t-shirt, even tho boots are more expensive than t-shirts.

 

Besides that, I need to filter the sales table since I don't want all transactions to be considered. Let's say I want to filter by ProductCategory. 

 

ClientIDNameLastName
1JohnJohnson
2MarySmith
3PeterMiller

 

TransactionIDClientIDProductNameSalesValueProductCategory
12Shirt5A
21Sweater15C
33Shirt5A
43Pants10D
52Socks1D
61Boots20E
71Shirt5A
82Boots20E
92Sweater15C

 

Thank you in advance. 

2 REPLIES 2
PDRTXRA
Helper I
Helper I

Not quite the solution I want. I explain in more detail what I'm looking for in this topic since the other one is marked as resolved.

pratyashasamal
Memorable Member
Memorable Member

Hi @PDRTXRA ,
This issue has already been solved in another community question .Please check out the below link :-
https://community.powerbi.com/t5/Desktop/Finding-Best-Product-per-Client/m-p/3032208

Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.