topic Re: Path error in DAX Commands and Tips

Path error

tearless — Mon, 19 Aug 2024 04:20:16 GMT

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?

Re: Path error

Jihwan_Kim — Mon, 19 Aug 2024 04:37:51 GMT

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.

Re: Path error

tearless — Mon, 19 Aug 2024 05:02:25 GMT

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?

Re: Path error

Jihwan_Kim — Mon, 19 Aug 2024 05:37:18 GMT

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.