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
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
Solved! Go to Solution.
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 😉
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!
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 😉
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
97 | |
88 | |
70 |
User | Count |
---|---|
165 | |
131 | |
129 | |
102 | |
98 |