Forum Discussion
lukaspowerbi
Helper II
Helper IIJoining 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...
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
Phil_Seamark
Microsoft Employee
Microsoft EmployeeHi lukaspowerbi
Have you considered merging the tables using then Query Editor?
This will allow you to create a new table that looks like your desired output.
Otherwise we can do this in DAX if you prefer
lukaspowerbiHelper II
Helper IIThank you.
I think I'll ttry to use the merge queries function and see how it goes.