Forum Discussion
Problem with merged Queries
Hello Team, I have two excel files. rows count in first file is 95,400 and in second file count is 68,000. after merging the second file into first all my measures are showing errors. all my coun...
Hi Anonymous ,
What kind of Join Kind did you use? I think you won't get total rows more than left one (95400) or Right one (68000). You get 163400 = 95400 + 68000, It looks like that you are trying to use Append function.
For reference: Combine queries
If this reply still couldn't help you solve your problem, please share a sample file with us and show us a screenshot with the result you want. This will make us easier to find the solution.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.