Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@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?
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.