Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
eliasayyy
Memorable Member
Memorable Member

price change percentage over time

hello everone i have 2 tables 

items table 

annonymous1999_1-1689841891303.png

 



price change table

annonymous1999_0-1689841874609.png


i need to add the price change to the price of my original 

example from jan 1, 2021 the price of I-1 was 75$, on jan 5 ,2021 , it was subjected to a 2.5% increase

so the new price on and after jan 5 2021 should be 75 + (75* 0.025) = 76.8$ 

more over , i have multiple items that has multiple changes over time , i need them to accumulate 

so on jan 5 2021 I-1 was subjected to the 2.5% increase of price but later on on march 30 2022 , it was subjected to another increase of 1% so in total it should accumulate to 75 + ( 75*0.035) 

here is data model for items and dates

annonymous1999_0-1689842251333.png

 

annonymous1999_0-1689842287002.png

 


i tried this measure but it fails 


annonymous1999_0-1689842422064.png

 

2 REPLIES 2
mlsx4
Memorable Member
Memorable Member

Have you checked the decimals? Because for 5 Jan, it may be rounding up

its not about the rounding its about how to accumulate the price changes over time based on the item id my formula is incorrect

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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