Special measure

[PaulBrunclair]

Hello Experts,

No idea on how to deal with this one, new on Power Bi.

Here are my tables and I have been asked to pup up materials that have been ordered by more than one customer.

I need to display each material with the name of the customers that have ordered this materiel and quantity.

I have customer, material, sales et calender tables.

I am stuck with no clue where to start🤔

Need you help guys 

Thanks

Material Table
Material ID	Description
91107745	HIFI
91107049	HOFO
91112114	HEFE
91108401	KEKE
91111289	BOBO
91100073	BIBI
91108091	FIFO
91111181	LIFO
91111535	RORO
	Customer Table
Customer ID	Customer name	City	Country
2054	COO	Ospedaletto (Pisa)	IT
2062	BOOO	Rudiano (BS)	IT
2067	COOO	Liesberg	CH
2068	DOOO	Wutöschingen	DE
2071	EOOO	Chemille Melay	FR
		Sales Table
Customer ID	Customer name	City	Material	Sales order ID	Dates	Order Quantity
2054	COO	Ospedaletto (Pisa)	91107745	101	02-07-24	25
2062	BOOO	Rudiano (BS)	91107745	104	06-07-24	30
2067	COOO	Liesberg	91112114	105	02-07-24	20
2068	DOOO	Wutöschingen	91108091	110	05-06-24	20
2071	EOOO	Chemille Melay	91108091	107	26-06-24	10
		Calender tabel
		Date	Month	Year
			Final result
	Month	Material ID	Customer ID	Customer name	Quantity
	June	91108091	2068	DOOO	20
			2071	EOOO	10
	July	91107745	2054	COO	25
			2062	BOOO	30

[Ritaf1983 · Accepted solution]

Hi @PaulBrunclair 

Please refer to the linked guide:
https://www.youtube.com/watch?v=SOYiImsOXgU

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[PaulBrunclair]

Hi Rita,

Awesome, that works great! Thank you so much🙏

Paul

[Ritaf1983]

Happy to help 🙂

[mickey64 · Accepted solution]

Step 0: I use your data below.

- Material -

- Customer -

- Sales -

- Calendar -

Step 1: I add some relationships below.

Step 2: I make a matrix.

[Ritaf1983 · Accepted solution]

Hi @PaulBrunclair 

Please refer to the linked guide:
https://www.youtube.com/watch?v=SOYiImsOXgU

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly