Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How to add max date from a date column in new custom column in Power Query in each cell
Can someone please help with the expression for this.
Solved! Go to Solution.
@amitchandak
I found that If we add the previous step reference in List.Max function then it works.
For example :- List.Max(#"Changed Type4"[Date column])
@Ramendra , I think List.Max should do
New custom column
List.Max([Date])
@amitchandak
Sorry but List.Max function do not work for date columns. It gives error in result column.
@amitchandak
I found that If we add the previous step reference in List.Max function then it works.
For example :- List.Max(#"Changed Type4"[Date column])