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
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors