Forum Discussion
Marking first instance for multiple items
NutNick1982 solution attached
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
It doesn't allow me to share the file on the forum..... the sample data i used to test your measure is below:
DateJob IDPercent Complete
| 5/31/2019 | 1A | 90% |
| 5/31/2019 | 2B | 80% |
| 6/30/2019 | 1A | 95% |
| 6/30/2019 | 2B | 85% |
| 7/31/2019 | 1A | 99% |
| 7/31/2019 | 2B | 90% |
| 8/31/2019 | 1A | 100% |
| 8/31/2019 | 2B | 95% |
| 9/30/2019 | 1A | 100% |
| 9/30/2019 | 2B | 99% |
| 10/31/2019 | 1A | 100% |
| 10/31/2019 | 2B | 100% |
| 11/30/2019 | 1A | 100% |
| 11/30/2019 | 2B | 100% |
| 12/31/2019 | 1A | 100% |
| 12/31/2019 | 2B | 100% |
NutNick1982 solution attached
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡