Expression.SyntaxError: Token ',' expected

DeeBali — Tue, 12 Mar 2024 21:46:14 GMT

Hell Fabric Community,

I am trying to use List.intersect function to fint common values across tables but everytime I do that, I recicve error Expression.SyntaxError: Token ',' expected

This is my code:

= List.Intersect( { 01_2024_SMBMI[Email Address], 02_2024_SMBMI[Email Address], 07_2023_SMBMI[Email Address], 08_2023_SMBMI[Email Address], 09_2023_SMBMI[Email Address], 10_2023_SMBMI[Email Address], 11_2023_SMBMI[Email Address], 12_2023_SMBMI[Email Address]}, Comparer.OrdinalIgnoreCase)

Can someone assist me if I have extra commas or missing commas in my code? Thank you so much.

Re: Expression.SyntaxError: Token ',' expected

lbendlin — Tue, 12 Mar 2024 21:57:09 GMT

You are using "funny" characters that you need to escape.

Instead of

01_2024_SMBMI

you need to specify

#"01_2024_SMBMI"

etc.

Re: Expression.SyntaxError: Token ',' expected

DeeBali — Tue, 12 Mar 2024 22:15:42 GMT

Thank you Sir.

topic Re: Expression.SyntaxError: Token ',' expected in Power Query

Expression.SyntaxError: Token ',' expected

Re: Expression.SyntaxError: Token ',' expected

Re: Expression.SyntaxError: Token ',' expected