Expression.SyntaxError: Esperava-se o token Comma - Help me please

[Anonymous]

= List.Min(Fechamento 2015[Dt.Emissão] & Fechamento 2019[Dt.Emissão])

What is wrong?

Thanks

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

I wonder what date type the columns are. Here are examples of '&'.

Expression:"A"&"BC"  Result:"ABC"
Expression:{1}&{2,3}  Result:{1,2,3}
Expression:[a=1]&[b=2]  Result:[a=1,b=2]

Here is the syntax of 'List.Min'. It is required a list as the first parameter. So the above formula needs to return a list.

List.Min(list as list, optional default as any, optional comparisonCriteria as any, optional includeNulls as nullable logical) as any

For further information, please refer the official document .

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-alq-msft]

Hi, @Anonymous 

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards

Allan

[amitchandak]

Seem like format issue

refer

List.Min({1, 4, 7, 3, -2, 5})

https://docs.microsoft.com/en-us/powerquery-m/list-min