Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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_g...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    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's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    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's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

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