Last seen: Jul 8, 2026
It would be helpful if you could upload a file containing some data and the queries you have merged. Don't forget to press "Start upload" before y...
In order to include the time intelligence you want, you must have real dates in the data table and make use of a calendar table in the data model. So,...
If you intended to add a file with the code "to look at", please try again. This time, press "Start upload" before you submit your reply.
Didn't see you latest message until now. Perhaps you can start by clarifying again what we are looking at. On Row 10 you say 7.20 and 3.25 correctl...
I'ts going to be difficult to help without a file. Can't you upload one after eliminating the confidential pieces? Leave the structure, column names a...
If you connect to the file with PQ, thus not open it in Excel, PQ should treat such a column as type "Any" (ABC123). Then you can change it to Text an...
If you intended to add a file, please try again. This time don't forget to press "Start upload*" before you submit your reply.
Thanks for the file. Any particular reason why it's in the old xls format? I couldn't really follow through your query as it connected to files in ...
The best way to analyze/understand a LET function is to see what every single step does. When you take my formula, replace the last word "return" with...
The file didn't come through. Please try again and don't forget to press the "start upload" button before you submit your reply.
Hi Tango, My schedule merely listed all dates with TRUE and FALSE as I had not understood in what other format you wanted the dates. Filter out the...
Hi Tammy, could you please upload a file containing an example of what you are experiencing? That saves us from having to create something that pro...
Not sure what's going on here. When I try to compare a value in a Time column to a text like "06:00" I get an error. So, I don't understand howe you g...
The file you intended to attach didn't come through. Please try again and don't forget to press "Start upload" before you submit your reply.
I suspect that this is due to the fact that you are dealing with texts, not real time values. Could it be that the time 08:40:00 contains a leading sp...