Last seen: Apr 15, 2025
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 ...
Hi Donnacha, That's a tricky one. In lesson 7.04 there is a lesson on lineage view, but this won't tell you what fields are in use, only how data is...
Hi Rennae, You shouldn't have to start again, but it's difficult to help you fix it without the file. Are you able to upload it here? Remove any sen...
Hi Bax, I would use the MySQL Database connector. This will allow you to have Power Query write the SQL for you and leverage query folding which pu...
Hi Rik, You can see the options for sorting PivotTables here. Mynda
Hi Sathish, Your file isn't attached. To attach it, select the file, click 'Upload', then wait for the grey check mark beside the file size before ...