First target from cumulative total

MrMani — Wed, 17 Jul 2024 01:34:40 GMT

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

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")

Re: First target from cumulative total

Jihwan_Kim — Wed, 17 Jul 2024 03:53:09 GMT

Hi,

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

MrMani — Wed, 17 Jul 2024 20:43:03 GMT

Thank you so much.

First month target acheived approach worked great in my model.

Appreciate your guidance.