Last seen: Jul 23, 2026
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...
Hi Amaro, It's difficult to help without seeing your file. However, the most important thing is that your data is stored in a tabular layout. If yo...
Hi Christoph, The file will only refresh when it's open. In which case you might be best to set it to refresh upon opening. Mynda
Hi Vivian, Create a dimension table that maps the clients to their respective groups e.g. Client Group A A B B C ...
Hi Valerie, I know I cover this in the Power Pivot course in the CUBE functions lessons for Excel. In Power BI a Slicer is just another filter, so ...
Hi Jim, Yes, the course is enough to do what you want. I have copied you on an email to another consultant. Be aware they charge more than the prev...
Hi Michelle, Are you able to share your file so I can see the data structure. Please also give me an example of the calculation you want to perform...