Two queries with same function but different results

[JCLai]

Hi all,

I am trying to filter the data from two different sources in between two dates. It was working fine up until I added some more functions. Right now one of the step is giving me what I want and the other throws an error. The function I have added works fine and they are simple function so I am suspecting something is wrong with Power Query.

The code works as intented as this query.

but it throws an error at the other one. The error starts from this step. 

They are both in the same excel file, refering to somewhat similar files.

Anyone could help me on this?

[Payeras_BI · Accepted solution]

Hi @JCLai ,

Find here an explanation and how to solve it.

[JCLai]

It works! Thank you for your help.