Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

= List.Min(Fechamento 2015[Dt.Emissão] & Fechamento 2019[Dt.Emissão]) What is wrong? Thanks
  • v-alq-msft's avatar
    6 years ago

    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.