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

Hi GGG123 

This video will help you create the MaxDate in a new column. https://www.youtube.com/watch?v=hidJ5T_DYQ0

You can then create a custom column

[NewColumn] - [Date]

 this will return a duration value

Hope this helps

Hello GGG123  ,

If my post helped you, please give me a 👍kudos and mark this post with Accept as Solution.

Try this solution.

let
    #"Reordered Columns" = YOURCODE
    LatestDate = List.Max(Table.Column(#"Reordered Columns", "Date")),
    AddedDateDifference = Table.AddColumn(Source, "Date Difference", each Duration.Days(LatestDate - [Date]), Int64.Type)
in
    AddedDateDifference

Best regards from Germany
Manuel Bolz

🟦Follow me on LinkedIn
🟨How to Get Your Question Answered Quickly
🟩Fabric Community Conference
🟪My Solutions on Github

Now I'm getting this error:

   DataFormat.Error: We couldn't parse the input provided as a Dat

It's so weird because until last month I never had problems with this Power Query model. 

Also, when I use the formula List.Max to find the latest date on a different paper, it works fine. 

I tried to changed the Date as Locale and play around a bit but still the same error.