cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

summarize points

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_groupsectionproduct_sub_grouppartnumber_suporder_amountpoints_audit
Repaired Eletronics3.cML3 repaired microprocessor125600822
Repaired Eletronics3.cML3 repaired microprocessor125601142
Repaired Eletronics3.cML3 repaired microprocessor125601222

 

Desired data

carrier_product_groupsectionproduct_sub_groupaverage_points_audit
Repaired Eletronics3.cML3 repaired microprocessor2

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: summarize points

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

Безымянный.png


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

Highlighted
Community Support
Community Support

Re: summarize points

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])
)

ggg2.PNG

 

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.

View solution in original post

2 REPLIES 2
Highlighted
Super User IV
Super User IV

Re: summarize points

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

Безымянный.png


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

Highlighted
Community Support
Community Support

Re: summarize points

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])
)

ggg2.PNG

 

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.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors