Forum

Hi Wendy, I cover Formula Firewall Errors in lesson 7.05. See if that helps. If not, please come back and let us know. Mynda

Bummer. I'd ask in the MS forum. You never know what other ideas that might come of it.

Hi Pieter, Thanks for creating the sample PDF. Power Query can't see the field data, so I think this is a non-starter for Power Query, unfortunatel...

Hi Pieter, I'm not sure what you mean by field name or field data, but Power Query can load any data from a PDF that's in a Table. Are you able...

Hi David, The icon configuration you're seeing is not because of your screen size. The first down arrow beside the Quick Access Toolbar icons revea...

Hi Kenneth, I would think so, but it's a bit difficult to follow what your formula is doing without an example file because on the face of it, MMUL...

Just confirming it's this (open the link to the image below rather than viewing this embedded image as it's distorted for some reason): If so, ...

Hi David, Do you mean the box with the file name and the down arrow? If so, this is available with Microsoft 365 accounts. What version of Excel do...

Hi Chris, Why don't you try using a PivotTable to get the count? Insert a PivotTable with column G in the row labels and the values area, with the ...

interesting, Cedric! Thanks for sharing.

Hi James, Disappointingly, Microsoft removed the sketched line style for charts. Apparently, there were some bugs that were too hard to fix. Myn...

Hi Amanda, I'd probably try and do the translation before loading to Power Query and cleaning the data as it's best not to modify the query output ...

Hi Deidra, Have you watched 7.01 Parameter Tables for Filtering? Let me know if you are still stuck after watching that and trying the techniques i...

Awesome to hear! You won't miss that again

Hi Danielle, Write a measure like so: Today = "Performance Framework to: "&TODAY() Use that measure in a text box (see image atta...