Looking for the sum of the Jan-Aug of 2020

[Anonymous]

I am looking for the sum of the Jan-Aug of last years HDD but I cannot get my formula to work.

2020 = CALCULATE(SUM(HDD[HDD]), HDD[Year]=2020, FILTER(Calendars, CALENDAR(DATE(2020,1,1), Calendars[Today's Month])))

[Samarth_18]

Hi @Anonymous 

Its always bit difficult to give precised answer without sample data and expected output. It would helpful if you could share the same.

In the meantime can you try below code:-

2020 =
VAR current_selected_date =
    MAX ( HDD[<Date column of your HDD table>] )
RETURN
    CALCULATE (
        SUM ( HDD[HDD] ),
        YEAR ( HDD[<Date column of your HDD table>] )
            = ( YEAR ( TODAY () ) - 1 ),
        MONTH ( HDD[<Date column of your HDD table>] ) <= MONTH ( TODAY () )
    )

 Thanks,

Samarth