add conditional column

[Anonymous]

How to add 'and' under 'add conditional column'? 

if 'target' is great than 2 and *****, then ***

[GilbertQ · Accepted solution]

Hi @Anonymous

In order to do that you will need to add a Custom Column

The syntax is the following below and NOTE that it is case sensitive

if [Target] > 2 and [Other column] = "Closed" then "My Output Closed"
else if [Target] > 1 and [Other column] = "Open" then "My Output Open"
 else "Other Output"

[Anonymous]

@GilbertQ thanks, but i don't really get it.  how do i add 'and' in the picture i attached?  see above. 

[GilbertQ]

Hi there you would add this as a Custom Column in the Edit Queries in Power BI Query Editor

[Anonymous]

@GilbertQ yes, i'm in edit queries/add column/conditional column.  but where to add 'and'

for example below, how should i say

if actualstart = 11/07/2017 and (or) ****, then output = 13/07/2017. 

[GilbertQ]

Hi there, instead of using the Conditional Column use the Custom Column and then paste the code in there.

Currently with the Conditional Column it does not allow you to put in the "and"