Last seen: Aug 18, 2025
Hi Salim, I haven't used Excel 2016 in a long time so not sure if this will work, but have you tried what's suggested in this post Play Audio an...
Hi Lea, I'm not getting an issue I'm afraid. When I run your query I get 59 rows loaded into excel. Regards Phil
Hi, Please supply your file so we don't have to recreate it. Thanks Phil
Hi Lea, I don't have any problem loading a table off that website using a new query - see attached file. Can you please supply your file so we c...
Hi MGB, I don't understand what you are trying to do. Maybe if you actually explain what your desired end result is - and supply a file with that ...
You can also use the IN operator when you want to use OR logic. = CALCULATE( sum([amount]), FILTER( 'AP-RAW', ...
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...