Mildly complex date difference formula

Hi @richmont,

No worries, I can just give you a hint then :slight_smile:

You can do followings:

  1. Create calculated column [Workday Not Holiday] in Date table. Make it 1 if it is workday and 0 if it is weekend.
  2. Create calculated column in your orders table etc where you count no. of days between order and delivery.
  3. From here, you can easily pick up which order are late etc.

You can take below example how to create calculated columns for workday/public holiday etc from this .pbix file.

1 Like