Help with price index based on 100 base price.

[Anonymous]

Hi guys,

Please I would like to ask you to help me to solve a question I am facing in Power BI because I have to build a report where it calculates a price index based on 100 base:

Filter : Brands, but if not possible I´ll try to adaptated the report.

matrix: the Ideal would be brands in row and  months in columns but if not possible it would not be a such big problem.

Behaviour:

When the client service team click over brand A on filter, the Matrix assumes that A is 100% and other brands varies so other brands can be 105%, 98% so on

When B is selected B is 100%

 Considering that price is value divided by volume I did:

Price_Index =
VAR Date_index =
CALCULATE ( MIN ( 'Test'[Month] ), ALLSELECTED ( Test ) )
RETURN
( SUM ( Test[Value] ) / SUM ( Test[Volume] ) )
/ (
CALCULATE ( SUM ( Test[Value] ), Test[Month] = Date_index )
/ CALCULATE ( SUM ( Test[Volume] ), Test[Month] = Date_index )
)
* 100

But with no expected result, Can anyone help me on this?

Thanks a lot!

[wdx223_Daniel]

If you can show some data to explain it, we might figure it out much quickly.

[Anonymous]

Hi Daniel, thanks for your replay 🙂

I tried to put a small part of my data with a example of what I need:
1-  group data by month.
2 - divide sum of value by sum of volume by month.
3 - divide value by volume for each brand.
4 - divide the step 3 by step 2 and multiply by 100.

where 69 is 6,07 / 8,78 * 100