Forum Discussion

xiuqinglim20's avatar
xiuqinglim20
New Member
2 years ago
Solved

null formula not working?

Hi there,   I am trying to add a conditional column where if the column value is blank, it will return me a "Y" value while if it is not blank, it will return me a "N". I believe the formula I am ...
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago

    xiuqinglim20 "blank" is not null. You have "" over there. So working expression is if [Column1] = "" then "Y" else "N".

AlienSx's avatar
AlienSx
Super User
2 years ago

Hi, xiuqinglim20 apparently [Column1] <> null otherwise you would see null in PQ editor in Column1. Something is in there - maybe space (" "). Try this formula: 

each if List.Contains({null, " "}, [Column1]) then "Y" else "N"

Just find out what is in Column1.