Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all,
I have been looking through other threads but was unable to find a solution to my probelm. Here is what I am trying to do:
I have the following table:
Status | Overall KPI | KPI1 | KPI2 | KPI3 | KPI4 | KPI5 |
Yellow | Red | Green | Green | Green | Green | Green |
I want to add a column that show me "correct" "incorrect" for
If at least one of KPI1-5 is red, then overall KPI is red,
If at least one of KPI1-5 is yellow, then overall KPI is yellow,
If Overall KPI is Green , then KPI1-5 are green
I feel like this should be simple but my brain does not let me find a solution at the moment.
Solved! Go to Solution.
[Blebleble KPI] =
var __kpis =
{[KPI1], [KPI2], [KPI3], [KPI4], [KPI5]}
return
switch( true(),
"Red" in __kpis,
"Red",
"Yellow" in __kpis,
"Yellow",
"Green"
)
[Blebleble KPI] =
var __kpis =
{[KPI1], [KPI2], [KPI3], [KPI4], [KPI5]}
return
switch( true(),
"Red" in __kpis,
"Red",
"Yellow" in __kpis,
"Yellow",
"Green"
)
Thank you! This works great as now I can compare this new column with the new column