Forum

Hi Sue, I would paste the Names in the Data sheet as values because the room data will change over time, so this shouldn't be a lookup formula. The...

Hi James, When you don't have any value fields in the PivotTable it will return all competencies/tasks. You'll see what I mean if you add the Prior...

Hi Peter, Thanks for sharing your file and very clear illustration of what you're trying to achieve. The solution is easy. Add a date column to ...

Hi Jacob, Welcome to our forum! Have you seen this tutorial on changing PivotTable aggregation methods using Excel Slicers? Hopefully that point...

Hi Krisztian, Have you checked the name manager and conditional formatting manager? Mynda

Hi Sue, My 'lookup' comments were in response to this paragraph in your original question: "I have been trying to link the name of the ward to t...

Hi Sue, If the names are too long, then you could give each person an identifier, like a unique ID. This will allow you to sometimes use the ID if ...

Hi James, You're so close! The only problem is that the Slicer is not from the Roles_List dimension table. Your Slicer is from the Roles table, whi...

Hi Mardi, You don't need the CELL function. Please refer to session 3.15 for OFFSET from the 2019/365 course. If you're still stuck, then email us ...

Hi Viet, You can merge the tables with a full outer join. See attached. Mynda

Hi Julie, Yes, you would have to create a separate dynamic named range for each contract column and another for the months. See session 3.75 of the...

Hi Brendan, You cannot store the data model in a different workbook to the PivotTables, sorry. If you're working with sensitive data like then then...

Hi Pam, If you want the field to remain a number, then you can't format it in Power Query. If you're happy to convert it to text then you can use P...

Hi Aye, Unfortunately, the screenshot is tiny and unreadable. Why don't you let the PivotTable provide contextual filtering and use SAMEPERIODLA...

Hi Lisa, Welcome to our forum! The 'days completed' was never a formula. This represents how many days' worth of project work is completed. It c...