Errors in custom column

[Sannat]

Hi super users, can you help a novice with this query please?

I've created a custom column to show when our next training refresher is due.  This is using the last booking date and adding the refresher cycle no. of years.  However, some of the rows show the training is yet to be booked "TB", this is creating errors in my new customer column.  I'd like the TB to appear in the custom column where no date is available, ie the error cells.  Can you tell me what I need to add to the syntax to achieve this please.  I've tried allsorts but being fairly new to PBI I could do with some pro help please?  Sure this will be obvious to most.   Thanks in advance.

[jennratten · Accepted solution]

Hello - here is how you can do this.

SCRIPT

Table.AddColumn(#"Replaced Value2", "Next refresher due", each if [Booking status] = "TB" then "TB" else Date.AddYears ( Date.From ( [Booking status] ), [Refresher cycle in years] ), type text )

RESULT

[Sannat]

Thanks for the swift reply, I'm just trying it out now.