cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Making an index for prices

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.

Thank you very much in advance!

Kind regards,

B

1 ACCEPTED SOLUTION
Super User

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

2 REPLIES 2
Frequent Visitor

Thank you very much!

Super User

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

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors