Do we have a IsNullOrEmpty condition ?

[joel_h]

In the M language, do we have a function that checks if a value is either null or an empty string?

Instead of the verbose

EmployeeWarning = if EmployeeId = "" or EmployeeId = null then "EmployeeIdMissing" else "",

Something like this

EmployeeWarning = if IsEmpty(EmployeeId) then "EmployeeIdMissing" else "",

 

[MarcelBeug]

No, but you can create one yourself with

= (String as nullable text) as logical => String is null or String = ""

By the way: be careful with "value".
In this case you mean a string; in Power Query, a value can also be a table, list, record or even a function.
For such values, you can use standard functions List.IsEmpty and Table.IsEmpty.