Previous Max Date Custom Column Using M

[atowriss99]

I have created a column to get the Max Date from a Date column in my table and now I want to create a new column to get the Previous Max Date.  

I tried this to get the it:
Table.AddColumn(#"Changed Type10", "Prev Max Rate Date", each Date.From(List.Max(#"Changed Type10"[Rate Start Date]))<(#"Changed Type10"[Max Rate Date])) 

and I get this error:
Expression.Error: We cannot apply operator < to types List and Date.

Details:
Operator=<
Left=[List]
Right=3/16/2024

Here's what I used to get Max Date: 
Table.AddColumn(#"Added Custom3", "Max Rate Date", each Date.From(List.Max(#"Added Custom3"[Rate Start Date])))

What steps do I need to take after adding my Max Date column to get Prev Max date?
Thanks

[v-xinruzhu-msft · Accepted solution]

Hi @atowriss99 

You can try the following code.

Table.AddColumn(#"Changed Type10", "Prev Max Rate Date", each List.Max(Table.SelectRows(#"Changed Type10",each [Rate Start Date]<[Max Rate Date])[Rate Start Date]))

Best Regards!

Yolo Zhu

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