Forum

That formula shouldn't fragment on inserting rows as it doesn't reference rows above/below itself. If you are pasting in data, then you must use Paste...

Hi Dan, Hard to say without the context of the file, but please see this tutorial on calculated fields:/p> If that doesn't work, then it will requ...

You can't. Power Query can't read Word documents. If the data is stored in Tables inside Word, you could create a PDF from the Word document and then ...

Hi Jesiah, You have a filter applied in the Timeline Slicer to only show 2024 data. If you clear the Timeline Slicer by clicking the red x in the to...

Without seeing an example of what you mean by 'different' it's impossible to comment further. Please share an example file that illustrates the issue ...

Power Query only shows you a preview of the data you're importing 999 rows. It does this so it can remain agile while you apply transformations. So, e...

The table in your invoice is called InvoiceItems. In the VBA code for clearing the invoice, it's referred to as InvItems. You need to change one of ...

Hi Mike, I just downloaded it from my blog post again and there's no error or new row for 2025 in the budget table, so I recommend you download it a...

Hi Mike, The only error I see in this file is on the Budget sheet on row 24. The #REF! error means the cell the formula referred to has been deleted...

Bee, This is happening because your query is appending ALL tables in your file. You need to go to the source step and filter out your table called ...

This will happen when you do not have the same formula in every cell above the new row. If a cell has a value, text or a different formula, it won't c...

Hi David, Right-click the Power Pivot PivotTable, choose Options, then on the Display tab, check the box for Show items with no data on rows (or if ...

I suspect you renamed the query and then loaded it to Power Pivot again. So, there's one query that has generated two tables. Go to the Data tab in ...

Yes, sorry, I meant semantic model. I wonder why you don't just use Power Query in Excel to get the data direct from the source then load to the Ex...

Hi Chris, I presume you are using Power Query to gather the data from the monthly files and consolidate it into one table from which you then create...