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])
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |