Minimum of date (error in expression)

[TomBond77]

Hi experts

I have created the following formula: Sum({<date={"<=$(=max([date]"))}, Year >} [Value])

I am getting this error message: 

Where is the problem?

Thanks

Tom

[tresesco]

Quote at the wrong place?

Sum({<date={"<=$(=max([date]))"}, Year >} [Value])

And even if this error correction doesn't help, try putting the date formatting function like:

Sum({<date={"<=$(=date(max([date])))"}, Year >} [Value])

[TomBond77]

Hi 

Still getting an error message with is formula:

Sum({<[Actual start: Execution (date)]={"<=$(=date(max([Actual start: Execution (date)])))"}, [Order: Manufact.Order(key)]>} [1])

Error message:

Any ideas.

thanks, Tom

[TomBond77]

meanwhile it is working. Instead of [1] as value I took a measure.

But now each row / data record is calculated by this formula. I only need the minimum date of an order of a preselected year. Therefore I think the year in the expression is not necessary anymore(?)