Expression.SyntaxError: Token ',' expected

[DeeBali]

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. 

[lbendlin · Accepted solution]

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

Instead of 

01_2024_SMBMI

you need to specify

#"01_2024_SMBMI"

etc.

[DeeBali]

Thank you Sir.