Last seen: Jun 7, 2025
Hi, No file attached. Click on the Start Upload button after selecting the file. regards Phil
Hi Lukasz, So you are writing SQL to query a database where the column names are changing? How does that work? How are column created/deleted i...
Nothing attached. Click Start Upload after you choose the file(s)
Hi Lisa, you can do this by: 1. Loading the table and duplicate the query so you have 2 queries. 2. In the first query filter out any rows th...
Hi Lisa, The 'dates' column is text, you can tell because all the values are aligned to the left of the column. The icon in the column header is al...
Hi John, Well done getting it working. It's all about keeping at it and learning, whatever your pace. If you get stuck then you can search thro...
Hi John, Jessica's approach is the way to go. Because you have a rate that changes based on (presumably) the Kwh you use, you can use VLOOKUP to g...
Hi John, Is this resolved? Jessica's answer is marked as the solution, but you've then added another reply and attached a file? Phil
Hi, You could do a test to see how many rows are in the table. If there are more than 1, then remove the last row = if Table.RowCount(Source) &...
I just looked over the error message again. It seems to have something to do with Right to Left languages. Are the people who get the problem using ...
Which ones get the error? The ones in a different building? I'm not sure how you could fix this. As I see it the problem is from a JS library loa...
Hi John, Can you please supply an example file with some data, showing what it is you want as a result. I'm having trouble understanding exactly...
Hi Ram, This looks like an error in a JavaScript library loaded from Microsoft. Where is your document/dashboard? On a PC, online? Is this h...
Hi Kasey, Nothing attached. Click Start Upload after selecting the file(s). Phil