Making an index for prices

[ase]

Good afternoon,

I am fairly new to PowerBI and I have a slight issue with creating a dax measure, which takes the price of a product in the beginning of the period as 100 (Base) and then based on the movements of the price over time gives me the percentage increase/decrease in price. 

Below is a simplification of the data to ilustrate the issue. 

Could someone please help me out with the creation of the measure? 

Thank you very much in advance!

Kind regards,

B

[ase]

Thank you very much!

[tamerj1 · Accepted solution]

Hi @ase 
Please refer to thr sample file with the solution https://www.dropbox.com/t/YtiyMYOrhy8EdsCp

Your method of calculating the percentage does not seem to be consistant. Please advise if I am missing somthing

Increse/Decrese = 
VAR ProductTable = CALCULATETABLE ( Prices, ALLEXCEPT ( Prices, Prices[Product] ) )
VAR BaseDate = MINX ( ProductTable, Prices[Date] )
VAR CurrentDate = MAX ( Prices[Date] )
VAR BasePrice = MAXX ( FILTER ( ProductTable, Prices[Date] = BaseDate ), Prices[Price] )
VAR CurrentPrice = MAX ( Prices[Price] )
VAR DiffirencePercent = FORMAT ( DIVIDE ( ABS ( CurrentPrice - BasePrice ), BasePrice ), "Percent" )
RETURN
    IF ( 
        CurrentDate = BaseDate,
        "Base Price",
        IF ( 
            CurrentPrice >= BasePrice,
            DiffirencePercent & " Increase",
            DiffirencePercent & " Decrease"
        )
    )