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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

IF function - from 2 columns

Hello

 

Im trying to set up an IF formula in a costum column to see witch columns have True on the same row

if [NI] = "TRUE" and [DT] = "TRUE" then "1" else "0"

 

I dont get any errors but i just dosent do the job

true fals.png

1 ACCEPTED SOLUTION
Anonymous
Not applicable

It is True/Fals datatype and that was the problem

I just figured out that if i removed the ( " ) it worked, so:

= if [NI] = true and [DT] = true then "1" else "0"

Worked like a charm.

 

Ty very mutch for answering tho Ruksuro 😉

View solution in original post

2 REPLIES 2
Ruksuro
Helper III
Helper III

Hi,

 

Assuming you have this stored as a True/False datatype your code should read:

 

Test = if(and(Sheet1[ColumnA]=TRUE,Sheet1[ColumnB]=TRUE),1,0)

 

The "TRUE" you've used is a string (because of the quotes), not TRUE. I've just tested and this doesn't work.

 

If your data type is actually a string, use:

 

Test = if(and(Sheet1[ColumnA]="TRUE",Sheet1[ColumnB]="TRUE"),1,0)

 

Hope that helps!

Anonymous
Not applicable

It is True/Fals datatype and that was the problem

I just figured out that if i removed the ( " ) it worked, so:

= if [NI] = true and [DT] = true then "1" else "0"

Worked like a charm.

 

Ty very mutch for answering tho Ruksuro 😉

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.