Custom Column: Conditional Value Return

Hi Plump_Lil_Monk ,

Please try this M code:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMlGK1UFlmGIwsErFAgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Year = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Year", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each 
  let 
    currentYear = Date.Year(DateTime.LocalNow()),
    AddedCustom = if [Year] = currentYear then "Current" else "Current + " & Text.From([Year] - currentYear)
  in 
    AddedCustom)
in
    #"Added Custom"

Put all of it into the advanced editor, and the final output is below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.