Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
hello everone i have 2 tables
items table
price change table
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
i tried this measure but it fails
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
17 | |
12 | |
11 | |
8 | |
8 |
User | Count |
---|---|
24 | |
12 | |
12 | |
11 | |
10 |