Target line to accumulate until end of year

[Anonymous]

Hello,

I am working on a combo chart which shows the bars for each year selected and a line for current year target only. The bars are displayed based on selection as required, however, i am struggling with the target line. Both bar and line accumulate over months i.e., the values adds up across months as shown in the image below. As you can see the target line stops adding up after current month. I am using the below expression for Target and the fields used on the chart are as shown below.

CALCULATE(SUM(Target[Target]),

FILTER(Target, Target[Year]=2021), 

FILTER(Target, Target[MonthNum]<=MAX('Textron Calendar'[Calendar Month Number])))

How do i get the target line to add up until Dec 2021 inspite of not having tickets for >Feb 2021?

[amitchandak]

@Anonymous , Try a measure with date table

YTD = CALCULATE(UM(Target[Target]),DATESYTD('Date'[Date],"12/31"))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.