Path error

[tearless]

Not sure why Path function works well when the column values are numbers but does not work when the column values are text. Could you please help me with this?

[tearless]

@Jihwan_Kim Thank you for the solution. It worked well with the dataset I attached above. However, when I replace the empty value with null in the actual (large) dataset, it does not replace the value... 

When I leave the query editor, the data does not change while the view shows it is replacerd with null as you see above. 

What am I doing wrong?

[Jihwan_Kim]

Hi,

Thank you for your message, and please share your sample pbix file's link (onedrive link, dropbox link, or others), and then I can try to look into it.

Thank you.

[Jihwan_Kim · Accepted solution]

Hi,

I assume the first table with blank has a value (blank-value) in column2, while the second table column2 blank shows null value.

Please try changing the blank-value like below in power query editor and then I believe you can see the expected result.