Forum

Hi Lea, This post explains how to insert an animated gif. Mynda

Sorry Cheryl, but I need a more explicit 'desired result' example. Your data is familiar to you, but it's not to me. When I look at the 'desired re...

Hmm, no idea why there are errors. Maybe the cache, but I wouldn't have thought there was a caching issue when you first connect. Anyway, I'd only ...

Hi Cheryl, Thanks for attaching your file. I presume it contains the two tables you want to merge. Can you also provide the desired result you'd li...

Hi Dave, Formatting like this isn't usually don't in Power Query as it's not designed to be the final output. It's better done in Power Pivot or Ex...

Hi Linda, If you put that measure into a PivotTable with nothing else does it return the correct value? If not, then I would go back to Power Query...

Hi Linda, To import the ODC did you go to the Data tab > Existing Connections as per tutorial 4.21 of the Power Query course? If yes, then what ...

Hi John, Thanks for attaching the file. If you use 'Get Data From Web' and then paste the file path into the web address field you can choose 'Tabl...

Hi Linda, I haven't experienced this but some research revealed a fix might be to try clearing the cache: File tab > Options and settings > Q...

Hi Prinsloo, It's kind of tricky because you need to reference the row below if the Amount column contains zero. In the attached file you'll see a ...

Hi Yan, The problem is that the CSV file dates are in mm/dd/yy format and your PC is probably in dd/mm/yy format, or vice versa. You need to change...

Hi Prinsloo, Welcome to the forum. Thanks for attaching your file. How would you identify which rows get combined? e.g. is it the rows that contain...

HNY to you too, Mark! I think the rule of thumb is to update all installs at the same time to avoid these problems, but I think you probably know t...

Hi Denise, Thanks for sharing the workbook and screenshot. The problem is caused when you try to load to a table and the data model. Normally you w...

Hi Alison, Please see file attached. Mynda