IF function statement for Power Query

if [Date] = null then 0 else 1

If it fails, you may need to transform the column to a Date type.


nested if:

if [#"Resource UID*"]="FIXED" then
  if [Shore] ="Onshore" then
     [Units]/30000
  else
     [Units]/7000
else
if[#"Resource Role (Job Catalogue)*"]="Student Assistant" then [Units]/1.886792452830189 else
[Units]/[Conversion Value]