Data table Aggregation for dates

Help Studio
, ,
6

@prasath17
Many thanks for this cross check I did update the statement

let mdt = grp.OrderBy(Function (x) CDate(x(1).toString)).Last()(1)

bold part was ommited - we want to fetch the col value.

Thanks for cross checking and enhancement
GroupBy_1Col_TakeLastMonth.xaml (7.5 KB)

the original data was without leading 0 in the month part but both are working

1 Like