Forum Discussion
Help with formula
Nikki add a custom column to calculate the status, you can do it in PQ or DAX, here is a DAX version
Status = SWITCH ( TRUE(), ( Table[Required] = "Yes" && Table[Completed] = "Yes" ) || ( Table[Required] = "No" && Table[Completed] = "No" ) || ( Table[Required] = "No" && Table[Completed] = "NA" ) || ( Table[Required] = "NA" && Table[Completed] = "No" ) || ( Table[Required] = "NA" && Table[Completed] = "NA" ), "Pass", ( Table[Required] = "Yes" && Table[Completed] = "No" ) || ( Table[Required] = "Yes" && Table[Completed] = "NA" ), "Fail", ( Table[Required] = "No" && Table[Completed] = "Yes" ) || ( Table[Required] = "NA" && Table[Completed] = "Yes" ), "Query" )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.⚡
Nikki add a custom column to calculate the status, you can do it in PQ or DAX, here is a DAX version
Status =
SWITCH ( TRUE(),
( Table[Required] = "Yes" && Table[Completed] = "Yes" ) ||
( Table[Required] = "No" && Table[Completed] = "No" ) ||
( Table[Required] = "No" && Table[Completed] = "NA" ) ||
( Table[Required] = "NA" && Table[Completed] = "No" ) ||
( Table[Required] = "NA" && Table[Completed] = "NA" ), "Pass",
( Table[Required] = "Yes" && Table[Completed] = "No" ) ||
( Table[Required] = "Yes" && Table[Completed] = "NA" ), "Fail",
( Table[Required] = "No" && Table[Completed] = "Yes" ) ||
( Table[Required] = "NA" && Table[Completed] = "Yes" ), "Query"
)
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.⚡
thankyou so much !!!!!
