Comparison of Current Year Deflated vs Previous Year

[Syndicate_Admin]

Good afternoon. Please need your help.

I have two periods anaules of sales distributed monthlymenes dode in each period there was a monthly inflation

Example in the month of January there was an inflation of 84% from January 2021 to January 2022.

My query is how I can do to deflate the month of January 2022 keeping the same amount of January 2021 in the same graph or table.

Translating it into precise numbers would require that for example January 2021 continues to be $55,741,897 but January 2022 should be $65,474,585

Thank you!!!!

[Syndicate_Admin]

Good morning. Thanks for the reply but unfortunately this is not what I am looking for.

I already have those two measures that you mention.

Average Annual Inflation = 76%

Sales Selected Year = SUM(Sales[Sales Amount])
Previous Year Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR ('Date'[Date]))

When creating two different measures I have no problem sticking to it on the two cards located on the left side of the report.

The problem I have is to be able to present it in the bar graph since it allows me to only locate a single measure and I just want to present in a single measure the selected year deflated through the function DIVIDE (Sales Selected Year, (1 + Annual Average Inflation) and Previous Year Sales

It's possible?

Thank you.

[v-xiaotang · Accepted solution]

Hi @Syndicate_Admin  @jtur 

how about using switch() or if() function in that measure? such like 

switch(true(),

min(table[year])= _current_year , your expression1, 

min(table[year])= _last_year , your expression2)

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Syndicate_Admin , You can try measures like

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))

or

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.