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  True A Pass Bill  True B Pass Bill  True C Fail Sue False A Pass Sue Fa...
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.

rafterse's avatar
rafterse
Helper I
2 years ago

looks like the file has expired 

 

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