Switching from DAX to M for nested IFs and TODAY condition

DateTime.LocalNow and DateTime.FixedLocalNow

https://docs.microsoft.com/en-us/powerquery-m/datetime-localnow

ImkeF probably knows about the switch statement.

While you can kind of do switch in M, for what you have if/else is good enough.

E.g.

= if [status] = "Open" and [Due Date] < DateTime.FixedLocalNow() then
     "Not Paid"
   else if [status] = "Open" and [Due Date] >= DateTime.FixedLocalNow() then
     "To be Paid"
   else
     "Paid"