cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Arman_Rzn
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

Each invoice has this four parameters for all Products.

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.

 

Thanks in advance

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

Hi @Arman_Rzn

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

 

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.

Helpful resources

Announcements
Microsoft Build 768x460.png

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_carousel_with_text (1).png

Charticulator Design Challenge

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

May UG Leader Call Carousel 768x460.png

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.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!