Forum Discussion
Merge Issue | Replace NULL
Hi, When i merge two table i am getting rows with null, the 1st table is 2017 and 2 is 2018 the data from 2018 is to the right of the 2017 period data and all looks good untill i have a account or store or line desc that did not exist in 2017 but it is in 2018, I am trying to find a way merge the first 3 columns (account, store, Line DESC) any ideas?
Thanks Z
Hi zibster,
Based on my test, after I replaced the "null" value to 0, I could just remove the left three columns to get the result you want:
You could downloadn the pbix file to have a view, if I misunderstand you, please just let me know.
Regards,
Daniel He
6 Replies
Hi,
below is the desired result Thanks:)
What do you see in Power Query? I've just done the same thing, and just filtered null out to load. Also what join did you do?
