Deflated Sales Selected Year

Thank you Ming Leng

I would need if you would be so kind of a little more of your help.

Figure 1:

• These would be nominal sales.
• % Price Increases: Year-over-year increases that occurred in the price list. In this case, they are the increases in 2024 vs. the price increases in 2023
• Net Growth: % growth at constant values (deflating the selected year 2024 vs. the nominal sales of the year 2023). As an example, in the month of January 2023 there was an 8% real growth since deflating the value of $1,087,822,571 from the invoiced value of the year 2024 where there was a price increase of 353.60% = $239,818,406 vs $222,049,649 = 8%

Figure 2: Growth Formula

Figure 3: Data structure

Figure 4: I applied the formula you indicated, but it doesn't work for me

Figure 5: Create a column in the Pbi table TOTAL INVOICED PRODUCTS where I deflated each invoiced item according to the billing date and the % year-over-year increase

Please appreciate your help.

Thank you!!