Forum

Hi Lea, This lesson looks at getting data from another file, but you can also get data from the current file as shown in lesson 2.03. The error ...

Hi Claudine, No screenshot attached, but you can always open the Advanced Editor and change the file path in there. You might need to do this on yo...

Hi Lea, I'm not sure I understand your question, sorry. Power Query will pick up new data from the practice file pq_3.02.xlsx if you make changes. ...

The PivotTable doesn't sound like the best solution. If all you want to do is find the latest date in your source data, you can use INDEX&MATCH as...

Looks like you're missing a second closing parenthesis.

Yes, just as you would for a list you generate. I see you already converted the Facility table to a list, so now in the Account query add a custom col...

Hi Aye, This is outside the scope of the course. Hopefully this post will point you in the right direction. Mynda

Hi Steve, It's great to see you're practicing using the examples here. I simply duplicated the Sources query to preserve Nick's original query, in ...

Hi Claudine, If you read the information at the link above it says "You can now refresh the Power Query queries in your workbook that pull data fro...

Thanks for sharing your file. You can generate the values in column X with this formula in cell X18, then copy down: =TEXTJOIN(",",TRUE,INDEX(IF(CO...

Hi Claudine, Does she have Office 365 for Mac or an earlier version? It's available for Office 365 subscribers in Excel for Mac running version 16....

Hi Mariena, It's not clear why you aren't able to use the report as is. It appears to show the total amount of new cases per month and year from th...

Hi Akh, Like we already said, you can't force any old range to recognise the # spilled range operator. It will only work when the data in the range...

Hi Charles, Transpose the table so the column labels are now in a single column. Then you can split the column to remove the .field part of the nam...

Only the E, C and W are upper case, the B is lowercase. Exactly like this: Excel.CurrentWorkbook