Presentation

Good

First of all, I'd like to introduce myself. I'm starting with Power BI with some tutorials and trying things out.

I imagine there will be people like me starting and stumbling every 5 seconds with some little problem.

I also wanted to take the time to tell you about my problem (if it doesn't go here you tell me and delete, which I don't just understand how the forum works).

The thing is, I have a dataset with football match data. In this data, there is a "TEAM" column where each action is referred to with the team it is next to. What I would like is to be able to relate in some way whether it is a Local or Visitor team. I thought about putting a conditional column with a formula that says "If PSG - Local". The problem is that when that team plays outside, it won't detect it as a visitor.

I have made a table with the columns: "JORNADA", "LOCAL", "VISITANTE" to relate them to the column "TEAM", but by linking two columns of one table with the same of another, what I get is that it remains as a hierarchical and when you choose the visiting team, it automatically filters you out of that match, but the local team.

Can you think of any way I can do it?

Thank you so much for the help.

Greetings.