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.⚡
NutNick1982 seems like I missed something, will try to reproduce at my end or if you can send pbix with sample data, it will be very helpful.
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.⚡