Deflated sales

[Syndicate_Admin]

Good afternoon community. I need your help to solve this problem. I want to be able to visualize in the same graph the sales of the selected year (from the YEAR friltro) where I am applying a measure of deflated sales and the sales of the previous year.

Could you please help me

thank you

[Syndicate_Admin]

I am informing as instructed:

1. Display the data as text, use the table tool in the edit bar

I have these available

I have these available

I	Jan.	feb.	mar.	Apr.	can.	Jun.	jul.	behind.	sep.	oct.	nov.	Dec.	Sales
2024	$1.283.942.698	$1.011.749.594	$1.071.749.780	$1.190.073.365	$1.229.783.217	$1.261.806.843	$1.758.881.253	$1.638.194.322	$1.510.622.807	$1.469.718.465	$1.494.499.036	$1.145.366.324	$16.066.387.703
2023	$291.957.468	$287.585.324	$400.136.147	$385.379.862	$413.341.577	$434.386.202	$612.516.061	$594.228.782	$801.746.855	$848.983.911	$808.452.981	$786.994.694	$6.665.709.863
Aum. Price	353,60%	356,82%	357,04%	312,84%	271,77%	251,31%	228,17%	162,79%	149,79%	100,53%	75,95%	30,10%

2. Expected Output of Sample Data

In short, these will be the expected values

2024 Deflated	$283.054.515	$221.476.005	$234.498.542	$288.267.952	$330.787.677	$359.169.410	$535.973.383	$623.374.595	$604.758.853	$732.910.943	$849.368.215	$880.350.255
2023	$1.324.326.722	$1.313.751.057	$1.828.778.227	$1.590.986.115	$1.536.697.316	$1.526.052.795	$2.010.068.129	$1.561.600.719	$2.002.677.726	$1.702.481.510	$1.422.506.962	$1.023.907.490
I think. Neto	-3%	-23%	-41%	-25%	-20%	-17%	-12%	5%	-25%	-14%	5%	12%

3. Explanation in words of how to obtain from 1. to 2.

I need that when selecting the year 2024 it shows me the values of the year 2024 deflated (without inflation - Example January 2024 / (1 + Price increase 353.60% = $283,054,515) but I need 2023 to show it as it was invoiced WITHOUT DEFLATING (nominally)

[Syndicate_Admin]

I have these no-thousand billing values for a one-off customer.

Analysis Period: Last semester of the year 2024 vs. last semester of the year 2023 selecting in the filter year 2024.

Valore available

Year/Month	jul.	ago.	sep.	oct.	nov.	Dec.	Total
2024	$41.019.362	$74.340.732	$31.223.287	$60.361.283	$54.574.277	$729.189	$262.248.129
2023	$33.156.243	$23.897.304	$25.396.886	$30.103.841	$36.574.484	$0	$149.128.758
Price increase (%)	228.17%	162.79%	149,79%	100.53%	75.95%	30.10%

The problem I have is that now I want to deflate the values of the year 2024 to compare constant values vs the year 2023.

Desirable values

Year/Month	jul.	ago.	sep.	oct.	nov.	Dec.	Total
2024 deflated	$12.499.585	$28.288.539	$12.499.850	$30.100.625	$31.016.183	$560.468	$114.965.251
2023	$33.156.243	$23.897.304	$25.396.886	$30.103.841	$36.574.484	$0	$149.128.758
Price increase (%)	228.17%	162.79%	149,79%	100.53%	75.95%	30.10%
Real Growth	-62%	18%	-51%	0%	-15%	100%

[Syndicate_Admin]

Ok thanks for the clarifications

I have these available

My	Jan.	feb.	mar.	Apr.	may.	Jun.	jul.	ago.	sep.	oct.	nov.	Dec.	Sales
2024	$1.283.942.698	$1.011.749.594	$1.071.749.780	$1.190.073.365	$1.229.783.217	$1.261.806.843	$1.758.881.253	$1.638.194.322	$1.510.622.807	$1.469.718.465	$1.494.499.036	$1.145.366.324	$16.066.387.703
2023	$291.957.468	$287.585.324	$400.136.147	$385.379.862	$413.341.577	$434.386.202	$612.516.061	$594.228.782	$801.746.855	$848.983.911	$808.452.981	$786.994.694	$6.665.709.863
Aum. Price	353,60%	356,82%	357,04%	312,84%	271,77%	251,31%	228,17%	162,79%	149,79%	100,53%	75,95%	30,10%

and I need that when selecting the year 2024 it shows me the values of the year 2024 deflated (without inflation - Example January 2024 / (1 + Price increase 353.60% = $283,054,515) but I need 2023 to show it as it was invoiced WITHOUT DEFLATING

In short, these would be the expected values

2024 Deflated	$283.054.515	$221.476.005	$234.498.542	$288.267.952	$330.787.677	$359.169.410	$535.973.383	$623.374.595	$604.758.853	$732.910.943	$849.368.215	$880.350.255
2023	$1.324.326.722	$1.313.751.057	$1.828.778.227	$1.590.986.115	$1.536.697.316	$1.526.052.795	$2.010.068.129	$1.561.600.719	$2.002.677.726	$1.702.481.510	$1.422.506.962	$1.023.907.490
I think. Neto	-3%	-23%	-41%	-25%	-20%	-17%	-12%	5%	-25%	-14%	5%	12%

[Greg_Deckler]

@Syndicate_Admin Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.