topic Re: Making an index for prices in DAX Commands and Tips

Making an index for prices

ase — Sat, 04 Jun 2022 23:55:37 GMT

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,

Re: Making an index for prices

tamerj1 — Sun, 05 Jun 2022 04:50:52 GMT

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" ) )

Re: Making an index for prices

ase — Tue, 07 Jun 2022 14:44:10 GMT

Thank you very much!