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.
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