Forum Discussion

BurakTurk's avatar
BurakTurk
Advocate II
8 years ago
Solved

IF DAX

Hi guys,    I got a pretty complicated problem as seem on the pic below.   I want to make calculation for value formula and that must be about if column has yes, return it to 1, if no return it t...
Need Help
  • tjd's avatar
    tjd
    8 years ago

    BurakTurk - Not sure what you're trying to do here, but here's a breakdown of the DAX I used: 

    NewValue = IF(File[Value]="YES", "1", IF(File[Value]="NO", "0", File[Value]))

    1. Create new calculated column called "NewValue"

    2. If File[Value] = "YES" then insert a "1" into NewValue

    3. If File[Value] = "NO", then insert a "0" into NewValue

    4. If File[Value] is not equal to either YES or NO, then insert the value of File[Value] (that would be your original 2, 3, 4, ...) into NewValue.

     

    The result is a column (NewValue) in the same table that has either a 1, a 0, or the original number from File[Value] in it.  Is that not what you wanted?  Not sure what you mean by "file [value] part, unfortunately, does not work on its own"; I tested it in PowerBI and it works.

vijay_kolisetty's avatar
vijay_kolisetty
Frequent Visitor
8 years ago

Hi

 

If you are not able to do it in DAX, try to make this solution in the table/view level and import into it.

Apologies if I didnt provide feasible solution if you are not importing the data from table/view.

 

Regards

V