Forum Discussion
admin11
Memorable Member
Memorable MemberHow to modify EXP expression to get Last Year Amount ?
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[sa...
Hi,
Download my PBI file from here.
amitchandak
Super User
Super Useradmin11 , Try like
AMOUNT_EXP_LY = CALCULATE([AMOUNT_EXP_], DATEADD('Date'[Date], -1, YEAR))
admin11Thank 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
Hi,
Download my PBI file from here.
- admin11