Forum

Hi Kelly, If the number of periods will be variable, then the DATEADD function may be what you need. I don't recall ever appending instead of me...

Hi Lisa, Yes, they should be able to refresh the query. Mynda

Hi Lisa, I wonder if it's less about the asterisk and more about it simply having a different name than what Power Query is expecting. You could te...

Hi Dieneba, 1. Correct. The fact table contains the transactional data. 2. Time on site is a transaction type of data, not a dimension. Dimensio...

Hi Ruth, I would avoid links to external workbooks. Instead, use Power Query to bring the data into the file containing the Pivot Chart. Regardi...

Hi Kelly, Assuming the files are all the same structure i.e. same column headers, then you should be appending the files. You can do this automatic...

Hi Christopher, A sample chart with some dummy data would be helpful to visualise the data you're dealing with. Mynda

Hi Rahul, You can do this with formulas too, however the count of digits used requires splitting the number into separate columns, then using COUNT...

If you don't apply any filters at Step 4 in the Consolidate Sheets with Power Query tutorial, then any new tables will be automatically included. T...

Those PDFs contain images, rather than tables. Power Query can't see the data because it's an image. That's why you can't select the cells in the PDF ...

They're not formatted as an Excel Table. Follow the link in my post above for Excel Table and you'll see what I mean. If you also open the file I shar...

Hi Dwight, Thanks for sharing the file. The only problem I see with that data is it isn't formatted in an Excel Table or defined by a name, as requ...

Yes, that's easy to fix but there's a few steps. Best if you can upload that sample Excel file and we can put the solution in the file for you.

Hard to tell much from that screenshot. If you click on the Error cell it will show you an error message with further information. That said, it l...

Hi Antonia, Try just using the data type drop down on the column to apply the Date Time data type. This should apply it using the nomenclature for ...