Last seen: Apr 19, 2025
It returns blank in a card because the card has no row context for the 'Date'. i.e. it doesn't know what the date is that it should be based on. I...
Rename the columns before appending so they match and then Power Query will know they are the same.
That's ok. You can download the data to one Excel file and then connect to that file with Power Query from a separate file to bring the data into the ...
Hi Gosia, You can append them and any columns that don't match will be empty for one dataset and vice versa. Mynda
Power Query offers a more efficient method for loading data into Power Pivot. If you load data already present in your Excel workbook into the Power P...
In theory, you should be able to save a copy of the file or rename the file and the queries and data model and connected PivotTables all relate to the...
Hi Linda, Glad you found a solution. I expect that your old PivotTables would need to be deleted to get rid of the connection to the old data mo...
Hi Gosia, You could add a column that converts the values in the Price Sold column to contain all positive values, let's call this column 'Value'. ...
Hi Danielle, Thanks for clarifying. When working with averages it doesn't make sense to subtract one period's values from another. In the file ...
Hi Danielle, Why are you dividing it by 86400? The source data already contains the average queue answer time, then the measure averages those valu...
Hi Shruti, Please see the comment/note below the video for that lesson. Mynda
Glad you figured it out. What version of Excel do you have? I ask because you're using the files from the 2010 to 2013 version of the course. If you h...
Hi Danielle, Thanks for the file. Please see file attached where I've focused on just one measure for the % Change v Prior Week Contacts Queued. ...
I'm a bit confused. To clarify, did the Date/Time column in Power Query had the Date/Time data type set? If so, it should feed through to Excel as a d...
Hi Douglas, You can edit the hard keyed reference to 'Weekday' with 'Column1' via the formula bar or advanced editor. That should fix the issue. ...