Last seen: May 17, 2025
Hi Robert, Welcome to our forum! It's tricky without an example file. If you have a Microsoft 365 license, you can use this formula: =FILTER(...
Hi Valerie, Great to hear you're making progress. Well done! It's very difficult to visualise all this information and help without seeing your ...
Hi Mattias, You can get import the climate zones using the csv, Excel, JSON or PDF file types on the ggis.un site. As for the issues you're expe...
Hi Anita, I've moved this question to the Excel Expert course members forum so that it gets answered promptly. Can you please upload a sample of yo...
Hi David, You're on the right track. If you prefer to have actuals, you'll need to remove the duplicate data on 23rd August at 6:23PM, 8:30PM, 9...
Hi David, Welcome to our forum! Yes, you can structure your data into a 3 column table. Use a PivotTable to summarise the data by date and time ...
My bad, I should have said Append, not Merge. No need to get files from folder, just get each CSV file using Get Data > From Text/CSV. See attache...
Hi Jim, File 2022-After_School_(in-person)2022-09-02_19_34_34.csv only has 37 columns. The second child names in 2022_Fall_Online_Classes2022-09-02...
Hi Kevin, Welcome to our forum! Please see this tutorial on displaying the grand total in a Pivot Chart. Mynda
Hi Jim, Because your dataset has duplicate column names, Power Query renames the duplicates 'First_Name_2', 'First_Name_3' and so on. It looks like...
Hi Loren, Glad you found a solution. The problem you had is different to Matthew's. Your issue was that the dates were incorrectly stored as text, ...
Hi Mukesh, Because you're enclosing the results you want in "", you are treating everything between the "" as text. To get the function to work re...
Hi Michelle, The table containing the diesel prices is not related to any other table in the model. If you create a relationship between the Diesel...
Hmmm, if you have a separate column for each course name then your data is not in the correct tabular layout for Power Pivot/PivotTables. Maybe that's...
Hi Vivian, It should be fairly straight forward. Using Power Query, extract a list of distinct client names from your fact table. This table will b...