new Calumn - Calculate with date from a different date-calumn

[n8schicht]

Hello,

i have the following list:

product;date;newone

xy-01;01.01.2017;0

xy-02;01.01.2018;0

XY-03;01.01.2019;1

XY-04;15.12.2018;1

the newone calumn i want to calculate with power query.
if "date" in date calumn is older then 180 days then 0 else 1

but how can i calculate these with power query?

thx

[parry2k · Accepted solution]

@n8schicht this will do it.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WqqjUNTBU0lEyMjA0B7JAnFgdiLARRNgCSTgiUtfAGCJsiSZsAlNtaKRraKoUGwsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [product = _t, date = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"product", type text}, {"date", type date}}),
    #"Inserted Age" = Table.AddColumn(#"Changed Type", "Age", each (Duration.Days(Date.From(DateTime.LocalNow()) - [date])), Int64.Type ),
    #"Added Custom" = Table.AddColumn(#"Inserted Age", "Newer", each (if [Age] > 180 then 0 else 1), Int64.Type )
in
    #"Added Custom"

[n8schicht]

oh - its so easy! if i know it!

thx