Forum Discussion

lukaspowerbi's avatar
lukaspowerbi
Helper II
8 years ago
Solved

Joining multiple tables/queries

I am trying to build a summary table displaying countries in one column and some numbers (Members,Joins,Expires) for those countries in other columns.   That is my desired (simplified) result: Cou...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi lukaspowerbi

     

    Sorry for the late reply.  Did you get this one sorted?

     

    I'm guessing there is a subtle difference in the spelling, or even a rogue space that needs to be cleaned for an exact match

lukaspowerbi's avatar
lukaspowerbi
Helper II
8 years ago

Hi Phil_Seamark.
You have been a great help. Thank you!!!

 

I have one more thing that I would like to ask you about if there is a way to do some work around.

I added a custom column and replaced null values from the first Country column by values in the 5th column.
However, there is Papua New Guinea that causes a bit issue. I attached a screenshot where I highlighted the issue in the pic below.

 

 

 

 

 

 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi lukaspowerbi

 

Sorry for the late reply.  Did you get this one sorted?

 

I'm guessing there is a subtle difference in the spelling, or even a rogue space that needs to be cleaned for an exact match