Forum Discussion
Merged columns not behaving as expected
I have two tables, merged into one. Now when I produce a table visual in power BI, I filter by certain criteria. It looks fine except one of the columns is not behaving as it should.
Now when I filter by one type, in my example below column A - isolating AA1 - It should be producing duplicate values in column C from the original data source but instead it is giving different values.
Unfortunately I cannot provide the real data but hopefully this is enough to explain? Table 1 and 2 merge to bottom table.
1 Reply
PCarson00 , Looking at data it should be two column join, you can select second column in merge by using Ctrl+click
If not what is expected output on sample data
If this does not help
Can you share sample data and sample output in table format?
