Forum

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...

No worries

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...