Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 ar...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

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

     

amitchandak's avatar
amitchandak
Super User
3 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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