Forum Discussion
Merge Issue | Replace NULL
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
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?
HI,
As you can see on my first pic the account, store and line_desc for 2018 is to the right of the data and where i have CHECK as line_desc in 2018 date it shows null in 2017 on the left, this is done with full outer join as some items did not exist in 2017 or in 2018. so i actuly can have null showing for the 2017 or for 2018 set. I know how to replace the Null values for the periods but i do not know how to combine the first 3 colums with last 3.
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