Forum Discussion
Solved
Merge Queries in Power Query
Hello community, I have data as below, Table 1: Date AccountCode Value 1/01/2024 null null 31/12/2023 null null 30/12/2023 null null 2...
pls try this
MrTechie, take a look if full outer join is really what you are looking for. https://radacad.com/choose-the-right-merge-join-type-in-power-bi
The main problem for you is that you use as the key columns 'date' and 'account code'. However, in your data you have 'account code' null in table 1 and something specific account in table 2. so instead of pairing, it creates two rows.
Perhaps left anti would be more suitable for you...