Powerquery add column If date in another column is more than a year ago

Hi Jo74 

I would propose something like this:

let
  Source = #table(
    type table [Created Date = date, Value = number],
    {
        {#date(2023, 12, 20), 65000},
        {#date(2024, 07, 15), 10000}
    }
  ),
  DateThreshold = Date.AddYears(Date.From(DateTime.FixedLocalNow()), - 1),
  #"Added New Column" = Table.AddColumn(
    Source,
    "New Column",
    each (if [Created Date] < DateThreshold then 0.5 else 1) * [Value],
    type number
  )
in
  #"Added New Column"

Are you able to get this working in your current query?

Hi Jo74 , and thanks OwenAuger .

Use this formula

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjLQNzTSNzIwMlbSUTIzNTAwUIrViVYyNNU3B4maAEUNDcCisQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Created Date" = _t, Value = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Created Date", type date}, {"Value", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each if [Created Date]<Date.From(DateTime.LocalNow()-Duration.From(365)) then 0.5*[Value] else [Value])
in
    #"Added Custom"

Hi Jo74 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Hi Jo74 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.