Forum

You're welcome. Maybe your employer will see the cost benefit to learning Power Query and will pay for your course 😉

Hi Amien, Sounds like there might be the odd cell that contains text values, not just numbers. Can you share a sample Excel file so we can take a l...

Hi Prorok, Try adding an Index Column to your table (Add Column > Index Column) before your List.Accumulate step. This should fix the error that...

In the 'Expanded Index' step it counts the instances of the 'Greek Letter-Date" pairs. I simply filtered out the 1st instances. In the attache...

Hi Juan, Glad it helped. From memory it took me about 10 minutes to prepare your file. It probably took me longer than it should have because I was...

Hi Tina, You don't need to turn the table into a query. I had to do that so I could Pivot your data again because you had pasted it as values. You ...

Hi, Please see the attached file, query 'Mynda' with table on 'Desired Final Output' sheet. Note: it relies on there always being a preliminary and...

Hi Juan, Thanks for providing the workbook and an example of the desired outcome. As Alan said, this makes it much clearer and we can be sure when ...

Hi Zach, As Alan said, it makes it much clearer, quicker and easier if you can attach a sample file. Thankfully your example was relatively easy an...

Hi Jenni, I wonder if my hour long webinar on Power BI would be all they need. It'll give them some insight into how it works and will familiarize ...

I think the best you can do with this data is a bar chart, assuming you want it all in one chart. If you add Slicers you can filter the data so you're...

Hi Wen, You have to give them a user account (not an author) on the data source. Where is your data stored? Presumably it is coming from some exter...

Hi Wen, I suspect it's the source data requiring the username and password. If so, you will need to get them set up with their own access to the so...

Hi Anne, No you can't add your own 'recommended PivotTables', but you can set a default PivotTable layout if you have Office 365 or Excel 2019. ...

Hi Juan, Probably, but it's difficult to say without seeing a sample file or images. e.g. you say there are two sheets, but I don't know what each ...