boolean on other boolean

[rafterse]

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	False	C	Pass

result needs to look like, 

User	Action
Bill	Test A Passed
Bill	Test B Passed
Bill	Retake test C
Sue	Complete Induction
Sue	Complete Induction

thanks 

[v-xuxinyi-msft · Accepted solution]

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]

looks like the file has expired 

[sanalytics]

@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

[sanalytics]

Hello @rafterse 

Please find the below pbix file for your output.

https://dropfiles.org/a6Tgg9LI

Hope it will help you.

Regards

sanalytics

If it is your solution then please like and accept it as solution