Forum

Hi Aye, This appears to be a duplicate question. I've answered it here: Mynda

Hi Aye, Thanks for attaching the Excel file. Please do this with every question where possible as this is the clearest way to explain what you're t...

Hi Daniele, To open the drop down list hold the ALT key and then press the down arrow. Then use the down arrow to scroll through the drop down list...

Hi Aye, Presumably you know the date you want to add because it's somewhere in your data already, just not in the correct format? If so, please pro...

If in February you have two new files that don't contain any queries, then you can copy the query from the January file (select it in the query pane &...

Hi Aye, No, you need a proper date to match to the other table. You don't have 'days of the month' in the other table, so it can't do a match. I...

Thanks for clarifying, but I have further questions to help with my understanding. When you get the February file do you discard the reason codes from...

Hi MissMia, Welcome to our forum. First of all, my understanding is that 'Report' is the source data file and 'Reason' is the file containing th...

Hi Aye, Power Query is the get and transform data tool in both Excel and Power BI. If your question is regarding a query, then please post it in th...

Hi Aye, I think there is some confusion in your understanding of Power Query, Power BI and Excel. Let me clarify; Power Query is the Get and Transf...

Hi Aye, It appears from the images in your first Word document that you just need to set the data type for the AccommDate field to Date only, not d...

Hi Aye, In Power Query you can bring the 'Available Bed' column into the Occupancy table by merging them and using the Facility and date columns fo...

Hi Aye, If you don't need to preview all of the queries you can turn off Background Data; go to Query Options > Data Load > deselect 'Allow d...

Glad you found a workaround 🙂

Hi Tracy, Thanks for sharing the second file. I can't see a 'Replace Value' step in any of your queries where you replace "MediaMark" with "Othe...