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 add a new meaure like this
First Reached to 100% =
VAR __date = CALCULATE ( MIN ( Table[Date] ), ALLEXCEPT ( Table, Table[JobId] ), Table[PerentComplete] = 1 )
RETURN
IF ( __date = CALCULATE ( MIN ( Table[Date] ), ALLEXCEPT ( Table, Table[JobId] ), Table[PerentComplete] = 1 ), "Yes" )
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.⚡
