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.

tjd's avatar
tjd
Impactful Individual
8 years ago

Greg_Deckler: You're one of my "Power BI heros" and you don't know the expected results?  It will be a numerical column of the desired values of the new calculated column "Value" by row "A", "B", ....  When put into a table or matrix it will show the sum of the A or B or ... columns.  Is that not obvious?

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

I guess where I was getting hung up was: "just keep the numbers and sum all values in the value column ." And I was thinking, so he either wants 1 or 0 or the sum of all of the values in the column? But, re-reading it again, I think you got it correct and I overthought the issue.