First target from cumulative total

[MrMani]

Need to help to find the first target from cumulative total.

and then highlight the months to achieve target

Lets set Target as 15

Measures:

"Pts Run" is a cumulative total

"Pts Tgt" = MIN (Pts Run,15)

Expected out put 

For id 1, it's acheived on April, Flag value is "Y" till April, remaining months to be marked as "N"

For id 2, it's acheived on March,Flag value is "Y" till March, remaining months to be marked as "N"

Unable to upload the sample pbix file. Pls find the details

Sample Data:

Table Name: Sample

id	dt	pts
1	1/1/2024	3
1	2/1/2024	4
1	3/1/2024	2
1	4/1/2024	7
1	5/1/2024	6
1	6/1/2024	2
2	1/1/2024	6
2	2/1/2024	4
2	3/1/2024	7
2	4/1/2024	1
2	5/1/2024	3
2	6/1/2024	5

Calendar table

Calendar = CALENDAR(MIN('Sample'[dt]),MAX('Sample'[dt]))

Measures:

Pts = SUM('Sample'[pts])

Pts Run = CALCULATE([Pts], ALLSELECTED('Calendar'[Date]),'Calendar'[Date]<=MAX('Calendar'[Date]))

Pts Tgt = MIN([Pts Run],15)

Pts Flg = if([Pts Tgt]<=15,"Y","N")

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood the question correctly, but please check the below picture and the attached pbix file.

INDEX function (DAX) - DAX | Microsoft Learn

[MrMani]

@Jihwan_Kim 

Thank you so much.

First month target acheived approach worked great in my model.

Appreciate your guidance.