summarize points

[jwi1]

Hi all,

I have an issue with below.

I want to transfom my current data table to the desired data table.

Can somebody help me out? 

Thanks!

John

Current data

carrier_product_group	section	product_sub_group	partnumber_sup	order_amount	points_audit
Repaired Eletronics	3.c	ML3 repaired microprocessor	1256008	2	2
Repaired Eletronics	3.c	ML3 repaired microprocessor	1256011	4	2
Repaired Eletronics	3.c	ML3 repaired microprocessor	1256012	2	2

Desired data

carrier_product_group	section	product_sub_group	average_points_audit
Repaired Eletronics	3.c	ML3 repaired microprocessor	2

[az38 · Accepted solution]

Hi @jwi1 

just put columns 

carrier_product_group

section

product_sub_group

on your vusiaul table.

then put column points_audit and set aggregation as Average in Visualization pane

[v-lionel-msft · Accepted solution]

Hi @jwi1 ,

Or create a calculated table.

Desired data = 
SUMMARIZE(
    'Current data',
    'Current data'[carrier_product_group],
    'Current data'[section],
    'Current data'[product_sub_group],
    "average_points_audit", AVERAGE('Current data'[points_audit])
)

Best regards,
Lionel Chen

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

[az38 · Accepted solution]

Hi @jwi1 

just put columns 

carrier_product_group

section

product_sub_group

on your vusiaul table.

then put column points_audit and set aggregation as Average in Visualization pane