Cannot convert the value #date to type List

Hi andi2333 ,

You're trying to evaluate the current row in a list context as you're applying your calculation to the current table (query step).

Try moving the max evaluation to the previous table/query step:

if List.Max([Real Date])=[Real Date] then "TRUE" else "FALSE"

// goes to:

if List.Max( PreviousStepName[Real Date]) = [Real Date] then "TRUE" else "FALSE"

You can actually simplify further by just using a logical expression:

List.Max( PreviousStepName[Real Date]) = [Real Date]

*BUMP* Repost as original apparently wasn't showing up.

Pete

in the case of using 

if List.Max([Real Date])=[Real Date] then "TRUE" else "FALSE"

the value of [Real Date] is not a list and is just a value in type date, if you want to refer to the whole column, you have to mention the name of previous step befor the name of column,

if the previous step is Source, rewrite the formula as 

List.Max(Source[Real Date])=[Real Date]