What is the easiest way to ADD a specific number of days to the Date?

[gerasimovav]

Hi colleagues!

I have to calculated deadlines: I have a shipment date in one table and promised delivery time in days based on carrier and the delivery location in another table.

If Carrier is 1 then we have to add his promised maximum delivery time (ZIPCodes[CarKPI]) to calculate Deadline. I've created such formula:

Delivery Deadline  =

if

(

[Carrier]="1";

DATEADD

(

SENDING[Shipping Date];

related(ZIPCodes[CarKPI]);

DAY

);

SENDING[Shipping Date]

)

But it doesn't work might be because dateadd work only with stable timeperiod to add. How can I easily solve this task?

[Anonymous · Accepted solution]

@gerasimovav 
Please add .[Date] after shipment date 

Delivery Deadline  =

if

(

[Carrier]="1";

DATEADD

(

SENDING[Shipping Date].[Date];

related(ZIPCodes[CarKPI]);

DAY

);

SENDING[Shipping Date]

)
If it doesn't work please share some sample data after masking.

[gerasimovav]

vimal_parmal!

Awesome! Surprisingly, it works!