Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rafterse
Frequent Visitor

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 

1 ACCEPTED SOLUTION
v-xuxinyi-msft
Community Support
Community Support

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:

vxuxinyimsft_0-1713772476780.png

 

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.

View solution in original post

4 REPLIES 4
v-xuxinyi-msft
Community Support
Community Support

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:

vxuxinyimsft_0-1713772476780.png

 

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
Frequent Visitor

looks like the file has expired 

 

@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
Solution Supplier
Solution Supplier

Hello @rafterse 

 

Please find the below pbix file for your output.

sanalytics_0-1713511916152.png

 

https://dropfiles.org/a6Tgg9LI

 

Hope it will help you.

 

Regards

sanalytics

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

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.