Hi, I have 2 queries with one common dimension. Both queries have a 1 to many relationship. I was able to merge the 2 queries, but the resulting table isn’t giving the answer I’m looking for. What I’m looking for is an outer join with all possible combinations.
try to set the „extend merge dimensions“ in document properties
Thank you, but I’ve tried that and it doesn’t work.