grouping a column in powerbi

[sniper007]

Hello
I want to sum the orders and the average price and the number of orders per family of items and not per item.
I want to try to create a set of families for each item,
for example in the column "LibelleArticle" :
the article "THALA GRIS EP 2 CM"  belongs to the family "  Marbre local" ...
so I simply want to create several families, each one has articles.

the families of the articles are:

Granite 

Marbre local 

Marbre imprté 

Onyx

Quartz 

Service 

[smpa01]

Can you provide sample data and expected output by pasting the same here?

[sniper007]

no i don't have any mappping table 

just i want to divide the LibelleArticle column into families each one contains articles 

[ryan_mayu]

@sniper007

do you want to transfer libellearticle to familiy? pls proivde detailed logic.

[Anonymous]

HI @sniper007,

Can you please share some more detail about the mapping logic that used to group your categories? It should help us clarify your scenario and coding formula:

How to Get Your Question Answered Quickly 

Regards,
Xiaoxin Sheng

[ryan_mayu]

@sniper007 

do you have a mapping table?

if you have ,you can use lookupvalue to get the family info