Forum

Glad you figured it out, Mark 🙂

Hi Anders, I think the SharePoint connector you're referring to is the correct one to use. When connecting to a SharePoint list, enter the site ...

Hi Matt, Perhaps you could use conditional formatting to hide them at that level of detail by formatting the font in the same green colour as the c...

Hi Paul, I think Anders is right. Rearrange your data so it's in a tabular format. Then you can leverage Power Query and Power Pivot to write the f...

Hi Matthias, If you post your VBA and question in our VBA forum I'm sure someone will help you figure it out. Mynda

Hi Dan, You'd have to write some VBA/Macro to do this. There's nothing in Power Query that can do this automatically. Mynda

Yeah, unfortunately some things are still a bit laborious. You could write some VBA to automate it if it's going to be a regular task.

Hi Katrina, It'll be a locale issue. Try right-clicking the date column > Change Type > Using Locale > here you can choose your location's...

Hi Dorothy, I suspect the query is getting data from all tables/sheets in the files. You're probably then loading your query into a sheet/table in ...

Hi Claudine, Your model is missing relationships between the Frequency and Business Day tables and your Closing Control Sheet. You have fields from...

Hi Arun, This is covered in session 7.01. Let me know if you get stuck after watching the tutorial and attempting it yourself. It will help if you ...

Hi Winnie, To change the data format; remove the ‘Changed Type’ step. Right click the date column > Change Type > Using Locale. In this menu ...

Hi Matthias, I would create two charts, one with the axis labels and one without. Then align the plot area manually by placing the chart without la...

Hi Cliff, Great to hear you're seeing the benefits of Power Query already. When making transformations on files from a folder, that you want app...

No problem, Matt. Let us know if you have any further questions.