I'm having some trouble with the Dax logic. I have a data set, which I don't have access right now, but the structure is simple:
Data - product ID - product description - brand - paid price
Each observation is a sold product. It is not grouped by quantity.
My objective is to group these events by date and brand, calculate the average price by brand, and also an competiveness index, which I'm struggling to create.
The index reasoning is not a big deal, I want to use a specific brand as a reference and calculate the relativity between the other brands.
For example, I have three brands, (Nike, adidas, puma). Referencing "Nike" as an example, I would like to divide the avg price from Adidas and puma separately, and as a final result understand the relativity between the brands.