Forum Discussion

Sannat's avatar
Sannat
Helper I
3 years ago
Solved

Errors in custom column

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 ref...
Need Help
  • jennratten's avatar
    jennratten
    3 years ago

    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

     

     

jennratten's avatar
jennratten
Super User
3 years ago

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's avatar
Sannat
Helper I
3 years ago

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