Forum Discussion
Post PartisanConditional lookup
NewbieJono you should transform the lookup table with these columns and then should be easy, basically each row will become 3 rows, one for green, one for orange, and another one for red.
Work Stream
Min Value
Max Value
Color Value
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.
NewbieJono see attached and tweak it as you see fit. I just changed the value in lookup table to see different colors:
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.
Super UserNewbieJono you should transform the lookup table with these columns and then should be easy, basically each row will become 3 rows, one for green, one for orange, and another one for red.
Work Stream
Min Value
Max Value
Color Value
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.
Post Partisansorry how would i do it frm here, woudl this create a many to many relationship? my table 1 will have many duplicate workstreams