How to modify EXP expression to get Last Year Amount ?

[admin11]

Hi All

I have below expression sales amount , it will plot current year :-

SALES_ = SUM(SALES[sales])

Below expression will plot last year sales amount :-

SALES_LY = CALCULATE( SUM(SALES[sales]), DATEADD('Date'[Date], -1, YEAR))

i will get chart look like below :-

Now i have expression for Exp Amount , it can plot current year exp amount :-

AMOUNT_EXP_ =
CALCULATE(
SUM(GL[AMT])*1,
FILTER(
GL,
GL[1_EXP]="EXP"
)
)

How to convert above expression , so that it will plot last year Exp amount ? So that i can get the chart look like above for expense.

My PBI file :-

https://www.dropbox.com/s/0vxehy63q1nz4h4/PBT_V2021_400%20GL_TI_3.pbix?dl=0

Paul

[amitchandak]

@admin11 , Try like

AMOUNT_EXP_LY = CALCULATE([AMOUNT_EXP_], DATEADD('Date'[Date], -1, YEAR))

[admin11]

@amitchandak 

Thank you for sharing. i have try you expression , and when i just plot your expression alone , it return correct result. see below image :-

when i combine your expression with 2021 Exp amount expression , it return wrong result :-

My PBI sample file :-

https://www.dropbox.com/s/to10ko59wgs9lww/PBT_V2021_400%20GL_TI_4.pbix?dl=0

Paul

[Ashish_Mathur · Accepted solution]

Hi,

Download my PBI file from here.

[admin11]

@Ashish_Mathur 

SamePeriodLastYear command working well , thank you very much

Paul

[Ashish_Mathur]

You are welcome.