Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Greetings,
I'm trying to write a statement for a column that shows 3 types of values: Complete, Not Complete, Not Assigned.
I need both "Complete" OR "Not Assigned" to return a "0", else "1".
I can write =if('Database'[Column]="Complete","0","1")) And that returns a 0 anytime it shows complete. What i can't get in one statement is for it to return a zero if it sees "Complete" or "Not Assigned" in the column.
Is that possible?
Solved! Go to Solution.
Hi,
Try this calculated column formula
=if(OR('Database'[Column]="Complete",'Database'[Column]="Not Assigned"),0,1)
Hope this helps.
Column = if('Database'[Column]="Complete" || 'Database'[Column]="Not Assigned","0","1"))
@Greg_Deckler This method also worked for me. all my visuals that hinged to that missing link then worked. thanks so much
Hi,
Try this calculated column formula
=if(OR('Database'[Column]="Complete",'Database'[Column]="Not Assigned"),0,1)
Hope this helps.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |