Forum Discussion

vishvz's avatar
vishvz
New Member
8 years ago
Solved

CASE Statement to DAX

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

5 Replies

  • rocky09's avatar
    rocky09
    Solution Sage

    vishvz

    try this

    Column = IF(Table1[Fraud score]=1,"TranscUSD","0") 
      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Community Champion

        vishvz

         

        Are Fraudscore and TrancUSD columns??

         

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