Monthly comparison by categories

[Syndicate_Admin]

Hello everyone.

I'm new to this power bi and dax thing and I need your help.

I have a record that contains thousands of products, each with its price and category (the category is divided into three levels in another table)

In addition, I have the date on which each of the records has been made.

I need a way to calculate and compare the evolution of prices over time (by months for example), both individually and by categories.

For example, see which are the categories/prices that have risen the most in price in the last year, or the ones that have risen the least. They have risen from one month to the next...

A small example of the table can be something like this.

Product	Price	Category	Date
AAA	5.3	A	01/01/2022
FIG	8.2	A	05/02/2022
BBB	1.1	B	01/01/2022
CCC	5.3	C	23/05/2022
CHAPTER	0.2	B	04/12/2022
DDD	2.7	A	03/03/2022
GGG	10.1	C	14/02/2022
HGT	20.3	C	23/08/2022
AAA	5.4	A	11/01/2022
CCC	6.1	C	17/09/2022
BBB	1.1	B	01/01/2022
DDD	.3.1	A	08/03/2022
GGG	9.1	C	29/03/2022

I imagine that we will have to calculate the average price of the category for the month in question, which is what I do not know how to do it.

I do not know if I have explained myself well or if it is necessary to clarify something.

Thanks a lot

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

If you want to calculate the average price of the category for the month, you can create a Dimdate table by CALENDAR()/CALENDARAUTO() function. Then create a measure by average function.

Data model:

Measure:

Avg = 
AVERAGE('Table'[Price])

 Result is as below.

Best Regards,
Rico Zhou

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