Average Selling Price

Hi, Anonymous 

According to your description, You want to generate a table, grouped by month and item, and calculate the total profit, total, and average for each item. Right?

Here are the steps you can follow：

(1)This is my test data:

(2) We can click "New Column" in the original table to create a year and month column:

Month = YEAR('Sheet4'[Billing Date])*100 & MONTH('Sheet4'[Billing Date])

(3)We can click “New Table” and enter :

Table =
ADDCOLUMNS (
    SUMMARIZE (
        'Sheet4',
        'Sheet4'[Month],
        'Sheet4'[Short Description],
        "Sum of w/o tax", SUM ( 'Sheet4'[Value w/o tax] ),
        "Sum of quatity", SUM ( 'Sheet4'[Billed Quantity] )
    ),
    "Average per Month", DIVIDE ( [Sum of w/o tax], [Sum of quatity] )
)

(3)Then we can meet your need ,the result is as follows:

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

Best Regards,

Aniya Zhang

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