Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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]))
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
Solved! Go to 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.
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.