Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Are Fraudscore and TrancUSD columns??
Column = IF ( Table1[Fraud score] = 1, Table1[TranscUSD], 0 )
not working
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.
Are Fraudscore and TrancUSD columns??
Column = IF ( Table1[Fraud score] = 1, Table1[TranscUSD], 0 )
yes both are columns
For example, fraud score has values 0 and 1
&
transaction amount has values in USD
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |