Forum Discussion

Nilrem's avatar
Nilrem
Frequent Visitor
9 years ago
Solved

Average calculation for distinct orders

How can I calculate average to take only once an order number [Transport No.]?   Example: Transport No.    MAX PCT AAA                   80 BCA                   75 AAA                   80 CA...
Need Help
  • Nilrem's avatar
    Nilrem
    9 years ago

    Hi Angelia,

     

    Thank you for your hints. I think the solution will be:

    1) Query editor -> Manage -> Duplicate

    2)Right click on the column in the new table -> Remove duplicates

     

    I think it will be automatic solution.

     

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Nilrem,

Please create a new table by clicking "New Table" under Modeling on home page. Please type the following formula, you will get distinct table.

NewTable = DISTINCT(Table1)




Then calculate the average based on the new table.

Best Regards,
Angelia

Nilrem's avatar
Nilrem
Frequent Visitor
9 years ago

Hi Angelia,

 

Thank you for your hints. I think the solution will be:

1) Query editor -> Manage -> Duplicate

2)Right click on the column in the new table -> Remove duplicates

 

I think it will be automatic solution.

 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Nilrem,

    Congratulations, you have resolved your issue by yourself. Please mark your solution as answer, so that more people will find the workaround easily. 

    Thanks,
    Angelia