cancel
Showing results for
Did you mean:
Frequent Visitor

## Calculate Average of Price in different Periods

Hi,

I am new here so I don't know if this problem was discussed or not.

there is column a = Price, column b = Quantity, column c = Product, column d = Person

Not only the price of one Product can be different for each person, but also each person may have bought the same product with different Prices.
For example the price of Product x is 100\$ at the beggining of the year and at the end of the year its price is 120\$, increasing in steps of 2\$.
So in each time period the average price can be different.

How can I calculate this kind of average?

My main problem is that calculating this kind of average is required that the program do the calculation by the time that is given by users not the premade formula.

I'll be thankful if anyone finds a solution for my problem.

2 REPLIES 2
Community Support

It is possible by a measure and a slicer.

However, it is not very clear for your information.

For example the price of Product x is 100\$ at the beggining of the year and at the end of the year its price is 120\$, increasing in steps of 2\$.
So in each time period the average price can be different.

how do you define a time perriod, it is a month or a quarter?

Best Regards

Maggie

Frequent Visitor

Well @v-juanli-msft thank you for your reply, actually it doesn't have a clear definition, I live in Iran and because of the unstable economic situation the sales manager decides to increase the prices at the moment.

And I have to find the Unit Price of each product that each customer have bought, by dividing the Sum price of that product by quantity... for example if there is 3 Product x with unit price of 100\$ and 1 Product x with unit price of 108\$ between August 1st and September 1st, I want to reach 102\$ as the unit price of the product x of customer y.
The main formula is: Sum of Price / Sum of Quantity (for each Product and for each person, by considering the time filtering)

I don't know how to cosnider time filtering. the department may want this for the first quarter, or any other Period. Beginnig and end of this period are not specified.

Is it clear now by these descripiton?

thanks.

Announcements

#### Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

#### Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

#### What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.