CASE Statement to DAX

[vishvz]

I want to create an expression like this using DAX  (new column) 

If fraudscore= 1 then return "TrancUSD" or else =0

Fraud score contain values 1 and 0.

regards

Vish

[rocky09 · Accepted solution]

@vishvz

try this

Column = IF(Table1[Fraud score]=1,"TranscUSD","0") 

[rocky09 · Accepted solution]

@vishvz

try this

Column = IF(Table1[Fraud score]=1,"TranscUSD","0") 

[vishvz]

not working 

[rocky09]

@vishvz

Not working means? Can you please atleast provide the error which are getting? Also, Please post some data. So, we can help you on this.

[Zubair_Muhammad · Accepted solution]

@vishvz

Are Fraudscore and TrancUSD columns??

Column =
IF ( Table1[Fraud score] = 1, Table1[TranscUSD], 0 )

[vishvz]

yes both are columns 

For example, fraud score has values 0 and 1 

 & 

transaction amount has values in USD