Forum Discussion
MrMani
2 years agoFrequent Visitor
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 (P...
- 2 years ago
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
Jihwan_Kim
2 years agoSuper 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
MrMani
2 years agoFrequent Visitor
Thank you so much.
First month target acheived approach worked great in my model.
Appreciate your guidance.