Create a summary table showing the articles bought by customers

[PaoloCantore]

Hello. I have a table in this shape:

Customer	Article	price
Peter	Bread	4
Peter	Milk	3
Julie	Milk	2
Peter	Crackers	3

Where the number of article is fixed (3 in this case bread, milk and crackers) and prices can be different for the same article. Every customer can buy an article only once. I need to create a table like this one where it is easy to check what articles a specific customer bought.

Customer	Bread	bread price	Milk	milk price	crackers	crakers price
Peter	yes	4	yes	3	yes	3
Julie			yes	2

So leaving the corresponding columns empty where nothing has been bought by a specific person.

Do you know how can I solve this problem with powerBi?

Thanks in advance to anyone that will give suggestion.

Best regards

Paolo

[PaoloCantore]

Dear Datainsights thank you very much for your precious help!

[DataInsights · Accepted solution]

@PaoloCantore,

This can be achieved with the measures below:

Bought = IF ( NOT ISBLANK ( MAX ( FactTable[Article] ) ), "yes" )

Price = MAX ( FactTable[price] )

Create matrix (use the measures in Values field well):