Forum Discussion
Error Token Comma Expected 'in'
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'
3 Replies
Anonymous , 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.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.
