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

  • 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.

     

     

     

3 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Community Support

    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's avatar
      v-alq-msft
      Community Support

      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