How to add if statement column values and give column name in else?

[bikelley]

Hello, 

I am trying to change some names in my column, but I am not sure how to give column names as default or on else. Can anybody please tell me.  Please see below image, 

The isseu is I am not sure how to reffer colunm name in If stament. 

Thank you so much

[amitchandak · Accepted solution]

@bikelley , Syntax is wrong , In dax it like

if([_rep>3] ,3,_rep) //if(<condition>, <then> ,<else>)

or is ||

and is &&

refer: https://docs.microsoft.com/en-us/dax/if-function-dax

[v-luwang-msft · Accepted solution]

Hi @bikelley 

You cold try  the following measure:

new accountname =
IF (
    'Account Name'[Ac+A1:A19count Name-Hierarchy level 2] = "Ch"
        || 'Account Name'[Ac+A1:A19count Name-Hierarchy level 2] = "Chi"
        || 'Account Name'[Ac+A1:A19count Name-Hierarchy level 2] = "Chic",
    "Chico",
    'Account Name'[Ac+A1:A19count Name-Hierarchy level 2]
)

final you will get like below:

DAX IF:https://docs.microsoft.com/en-us/dax/if-function-dax 

or in dax:||

and in dax:&&

 if i answer your question,pls  Mark my post as a solution,thanks!

Best Regard

Lucien Wang

[bikelley]

@v-luwang-msft  Thank you so much this works well for me too. Again, thanks for the help. 

[amitchandak · Accepted solution]

@bikelley , Syntax is wrong , In dax it like

if([_rep>3] ,3,_rep) //if(<condition>, <then> ,<else>)

or is ||

and is &&

refer: https://docs.microsoft.com/en-us/dax/if-function-dax

[bikelley]

@amitchandakThank you so much this makes sense. I appreciate your time.