Merge Issue | Replace NULL

[zibster]

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

[v-danhe-msft]

Hi @zibster,

Could you please post me your desired result?

Regards,

Daniel He

[zibster]

Hi,

below is the desired result Thanks:)

[flogan2000]

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?

[zibster]

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

[v-danhe-msft · Accepted solution]

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.

https://www.dropbox.com/s/rhzlq40lnniyrgn/August%202018%20update%20We%20cannot%20convert%20the%20val...

Regards,

Daniel He

[zibster]

Thanks for yout help Daniel