Adding number of days to a date based on another column

[samc_26]

Hi, so I have a column with dates and then another coulm with number of days until a service is due on some data and I can't work out how to get the desired output. I don't think I can use the Date add days thing as the number of days change depending on the row. I tried just adding them together but it just gave me errors. 

My data looks like this: 

Date	Days	(Output I'm hoping for)
01/01/25	30	31/01/25
01/02/25	25	26/02/25

If anyone can advise I would be very grateful! Thank you 

[pankajnamekar25 · Accepted solution]

Hello @samc_26 

You can create a calculated column

Service Due Date =

    'Table'[Date] + 'Table'[Days]

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[samc_26]

Brill thank you, I was doing that sum but in power query which wasn't working, this worked great! 

[Vijay_Chethan]

Hello samc_26,
can you explain what exactly do you mean by "giving error",because im sure we could use dax calculated columns to get your desired output