Forum Discussion

rafterse's avatar
rafterse
Helper I
2 years ago
Solved

boolean on other boolean

Help please 

this is the data 

User_Induction complete_Test name_Test result_ 

Bill 

TrueAPass
Bill TrueBPass
Bill TrueCFail
Sue

False

APass
SueFalseCPass

 

result needs to look like, 

 

 

User Action
BillTest A Passed
BillTest B Passed
Bill

Retake test C

Sue

Complete Induction

Sue

Complete Induction

thanks 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi rafterse 

     

    Thanks for the reply from sanalytics .

     

    If your problem has not been resolved, try the following:

     

    Create a calculated column as follow

    Action =
IF (
    [Induction complete_] = "False",
    "Complete Induction",
    IF (
        [Test result_ ] = "Pass",
        "Test " & [Test name_] & " Pass",
        "Retake test " & [Test name_]
    )
)

     

    Create a calculated table as follow

    Table 2 = SELECTCOLUMNS('Table', "User_", [User_], "Action", [Action])

     

    Result:

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi rafterse 

     

    Thanks for the reply from sanalytics .

     

    If your problem has not been resolved, try the following:

     

    Create a calculated column as follow

    Action =
IF (
    [Induction complete_] = "False",
    "Complete Induction",
    IF (
        [Test result_ ] = "Pass",
        "Test " & [Test name_] & " Pass",
        "Retake test " & [Test name_]
    )
)

     

    Create a calculated table as follow

    Table 2 = SELECTCOLUMNS('Table', "User_", [User_], "Action", [Action])

     

    Result:

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • sanalytics's avatar
      sanalytics
      Super User
      2 years ago

      rafterse 

      Sorry for the inconvenience.

      It is some kind of shame of the Microsoft and the dark side of this community rules restrict some users from attaching PBIX files directly to their posts, while others can. This inconsistency forces us to resort to external links for file sharing, which can be frustrating.

      All contributors on this platform are working professionals dedicating extra time outside of their jobs to enhance their skills and help others. It would be beneficial if Microsoft could provide all users, including new contributors, with the option to share files directly.

      Such a change would promote a more inclusive and efficient environment for knowledge sharing and collaboration within the community.

       

      Regards

      sanalytics