Forum Discussion

GGG123's avatar
GGG123
Regular Visitor
2 years ago
Solved

Issue with List.Max ([Date]) in power query

This formula      Date.From(List.Max(Table.Column(#"Reordered Columns", [Date]))) - Date.From([Date])   is returning this error Expression.      Error:    We cannot convert the value #date(202...
Need Help
  • GGG123's avatar
    GGG123
    2 years ago

    I finally worked it out. All I did is to go at the beginning of the code and Filtered Out "Undeposited Items" which was mentioned in the error I was getting 'DataFormat.Error: We couldn't parse the input provided as a Date'.

    The thing that I couldnt understand is that when looking at the Column Profile, everything showed 0 Error and the count seemed to be all in order. 

    Thanks for your help anyway!