Forum Discussion
First target from cumulative total
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
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
2 Replies
- Jihwan_KimSuper User
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
- MrManiFrequent Visitor
Thank you so much.
First month target acheived approach worked great in my model.
Appreciate your guidance.