MAX of date in query editor

[Suryaann]

Hi All,

Help needed.I want to get the recent date present in a date column in query editor.In my case i cannot do it in dax.

So kindly help to add a new column MAX(date) in query editor

Sample table column

Date                Max(date){New column}

1-01-2019       3-01-2019

2-01-2019       3-01-2019

3-01-2019       3-01-2019

[HotChilli · Accepted solution]

Add a column in Advanced Editor

#"Added Custom" = Table.AddColumn(#"Removed Columns", "Custom", each List.Max(#"Removed Columns"[Date]) , type date)

#"Removed Columns"    should be the name of the previous step