Solved: Two queries with same function but different resul...

JCLai · ‎05-05-2023

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 · ‎05-05-2023

Hi @JCLai ,

Find here an explanation and how to solve it.

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

View solution in original post

Payeras_BI · ‎05-05-2023

Hi @JCLai ,

Find here an explanation and how to solve it.

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain