Error Token Comma Expected 'in'

[MHoque]

Hi,

I am getting 'Token Comma Expected' error but I cannot seem to understand how to resolve this one as the error is indicate at/under 'in'.

I have checked commas on all other lines and they are not showing as errors either.

Appreciate any help.

Error is indicated under 'in'Error is highlighted at 'in'

[amitchandak]

@MHoque , Check that firstCol is a list? Also, check the thridcol line.

We need to remove the code and check what is causing the error.  Not visible in screenshot

If this does not help
Can you a sample pbix after removing sensitive data.

[MHoque]

Hi Amitchandak,

Thanks for responding.

I'll start off by what I am trying to do (maybe that will be easier).

I have a list of teams which are in 2 columns (home and away). I would like to create a third column with all distinct values from both columns as not all teams are featured in both lists.

I can then aggregate other values such as attendance, matches played etc, whereas right now I can only do that for Home teams or Away teams seperately.

Let me know if you need anything else, thanks again.

[MHoque · Accepted solution]

Nevermind, I actually managed to get what I needed with this Union Join