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
Need Help
Show and Tell
  • rocky09's avatar
    rocky09
    8 years ago

    vishvz

    try this

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

    vishvz

     

    Are Fraudscore and TrancUSD columns??

     

    Column =
IF ( Table1[Fraud score] = 1, Table1[TranscUSD], 0 )
rocky09's avatar
rocky09
Solution Sage
8 years ago

vishvz

try this

Column = IF(Table1[Fraud score]=1,"TranscUSD","0")
vishvz's avatar
vishvz
New Member
8 years ago

not working 

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    vishvz

     

    Are Fraudscore and TrancUSD columns??

     

    Column =
IF ( Table1[Fraud score] = 1, Table1[TranscUSD], 0 )
    • vishvz's avatar
      vishvz
      New Member
      8 years ago

      yes both are columns 

       

      For example, fraud score has values 0 and 1 

       & 

      transaction amount has values in USD 

  • rocky09's avatar
    rocky09
    Solution Sage
    8 years ago

    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.