[SOLVED] Excel ISNULL, ISBLANK type custom function in Power Query M

I call this function `ISPRESENT` to test for values that are not null, empty strings/blanks or zeros.

me@jaykilleen.com wrote this over 2 years ago and it was last updated over 2 years ago.


← Back to the Posts

let
   f = (x) =>
      let
         x = if 
           x = null then false
         else if 
           x = "" then false
         else if 
           x = 0 then false
         else
           true
      in
        x
in
   f

Similar