Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
Hi,
Download my PBI file from here.
@admin11 , Try like
AMOUNT_EXP_LY = CALCULATE([AMOUNT_EXP_], DATEADD('Date'[Date], -1, YEAR))
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
Hi,
Download my PBI file from here.
You are welcome.
User | Count |
---|---|
87 | |
84 | |
70 | |
62 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |