Assigning values in a new column based on dates

Hi RichOB ,

Thank you for reaching out to the Microsoft Community Forum.

Hi Poojara_D12  and GrowthNatives , Thank you for your prompt responses.

Hi RichOB ,

You need the column status to be satisfy the below 3 conditions.

1. If the issued date of the new check (per property) is the same as the previous expiry date = Completed On Target

2. If the issue date is before the previous expiry date = Completed On Target

3. If the issue date is later than the previous expiry date = Completed Outside of Target

Please refer below output snap and attached PBIX file.

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh