Forum Discussion
Deflated sales
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
4 Replies
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.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%
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% I am informing as instructed:
1. Display the data as text, use the table tool in the edit barI 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)
