Forum

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...

No, you can't connect DAX to a cell in the spreadsheet. It can only reference data in the data model.

Hi Vestal, You can lookup a URL and convert it to a hyperlink using the HYPERLINK function wrapped around the lookup formula, but you can't lookup a...

Hi Del, You can use the FILTER function or PivotTables to extract data. If you get stuck, please provide an example Excel file so we can help you ...