How to show bar chart with sum of only latest month for each year

[Lucius_Artorius_Castus]

Hi, So I want to sum only latest month for each year like below

Right now as you can see i am able to generate this chart till 2023 with this expression SUM({<[CREATED_DATE-Year-Month.autoCalendar.MonthRelNo] = {"-10"}>} [FA_QTY_FUNC] * [AVERAGE_PRICE]) / 1000)
because it has latest month which is 12, but for 2024 latest month is Feb so I want to only sum for feb data
Please Let me know how should I achieve this.

Thanks.

[Lucius_Artorius_Castus]

@Anil_Babu_Samineni Is there possible way to do this without data script? I am not using script for my dashboard, so Is there way we can do this in expression?

[Lucius_Artorius_Castus · Accepted solution]

I solved this by creating new two columns Latest_YM where I am storing latest month of specific year and second is YMFlag field I have created where I am subtracting both date fields if it is 0 then I put flag 0 otherwise 1
if (interval([Year-Month]-[YEAR_MONTH_CALC], 'd') = 0, 0 , 1)

And in expression I have filtered with SUM({<[YMFlag]={'0'}>} [FA_QTY_FUNC] * [AVERAGE_PRICE]) / 1000) 

 Thanks everyone for helping me. If there is better solution Let me know but this work for me for now.