Forum

Hi Cynthia, Thanks for sharing your file. The problem is the dates in column A of the Data Table are text and Excel can't read them as dates. They ...

Hi Doug, Please upload a sample Excel file. Be sure to include a few students' data so we can see the layout of the table. I think you can use a fo...

Hi Kelli, Welcome to our forum! That's odd. Are you logged in? Mynda

Hi Anita, I think Jessica is picturing the data in PQ is in separate columns as it appears in your screenshot, but presumably you have one column c...

Hi Michele, If you look at my Project Management dashboard you can modify it so that the Project name appears in the highlighted cells instead of j...

Hi Anita, What you want to do is group AV together and PV together and then take one group from the other, but when you group items in regular Pivo...

Hi Raymond, Great to see you're making use of the new dynamic array functions. You should be referencing the spilled results of dynamic array formu...

Hi Pieter, You need to perform a logical test to check if the rows in the UpdateColours table = the 'Old' value in the TextSubs query. If TRUE, the...

Hi Mike, Welcome to our forum! Glad you enjoy my videos There's no built-in way to automatically move the PivotTables closer together as rows b...

Thanks for clarifying. Power Query it is then. 1. Format the data on each sheet in an Excel table (CTRL+T). The tables will be named Table1, Table2...

Thanks for the file. What version of Excel do you have? If you have Microsoft 365 or Office 2021 then you have the new dynamic array functions, which ...

Thanks for the screenshots. The data types for those columns are not set in Power Query. Both are type 'Any'. If you set the data types, do they then ...

Hi Saliha, You can use COUNTIF to add a count of the B/e No records and then use a PivotTable to get your layout. See attached. Mynda

Hi Moriel, As I mentioned, I can't open your queries and you haven't said which columns you've added, but if I look at the tables in Power BI and s...

Hi Jacqui, You can protect the sheet objects (charts, images etc.). By default all objects are locked, you just need to enable the protection on th...