Expanding table in Power Query - preview shows correct value, but after expanding its incorrect

[lenkanovy]

Dear comunity, 

I'm merging two tables to get data into first table. When I merge the two tables and click into new column to see preview of which row was mapped to the row, it shows correct value. When I expand the column and choose columns I want to see, the values in row change to incorrect, see screenshots.

- preview of data 

- after expanding data

- data in second table

So far I've tried: reloading data, creating again tables, changing data format, updating power bi desktop, clearing caches and wirking with it on different device.

[v-achippa]

Hi @lenkanovy,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin and @Omid_Motamedise for the prompt response. 

As we haven’t heard back from you, we wanted to kindly follow up to check if the response provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @lenkanovy,

We wanted to kindly follow up to check if the response provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @lenkanovy,

We wanted to kindly follow up to check if the response provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[Omid_Motamedise]

When you expand the merge column, please also consider name and see the result

[lbendlin · Accepted solution]

Your code seems rather complex.  Can you strip away anything that is not relevant to the issue?

Have you considered using lookups via Table.AddColumn  instead of merges?

[lenkanovy]

Hello,

thank you for this answer. I created two new columns by using

= Table.AddColumn("Table1", "New column name", each let match = Table.SelectRows("Table2", (x) => x[Merged] = [Account number]) in if Table.IsEmpty(match) then null else match{0} [Group name])

and now it's working.