Forum

Hi Brendan, Welcome to our forum! Thanks for sharing your file. First, you need to create a date table that has a consecutive set of dates from ...

Hi Steven, Like the chart in the attached file (I assumed you meant 'date on one axis' not 'data')? Note: you probably want to exclude NA from the ...

Hi Steven, Last time I looked at this I showed you how to use Power Query to calculate the number of licences in the 'CrewPlan' query. What happene...

Hi Erik, It sounds like your updates haven't been applied properly. Perhaps you could try repairing Office and or reinstalling it. Mynda

Hi Salman, Thanks for sharing your file, however I'm not understanding where you got the figures for the 'Best of Network' in column P of the Pivot...

Hi Erik, Did you save the Excel file containing the query? What is the data source your query is connected to? Have you tried this with any other f...

Hi Fatjon, It's very difficult to help you without seeing at least screenshots, which you can anonymize before sharing. You haven't said what th...

Hi, Welcome to our forum. The dynamic named range formulas should all count a column that will always contain data, in your example that would b...

Hi Salman, Please upload the image again, it didn't work. Note: an Excel sample file would be better than an image, if you can. Mynda

Hi Tan, It's dead easy and pretty self explanatory if you just turn them on and select the cell containing the total you'll see it has a drop down ...

It's the 'Hide from client tools' technique.

Hi Salman, Your RAM might have something to do with it, but it might also be the data source and your query structure. Perhaps you can provide some m...

Hi Vivian, Perspectives allow you to define tables and fields for a particular user group or business scenario, making it easier to navigate large ...

Hi Joe, You need to use Power Pivot to do this as you need the DAX function, SAMEPERIODLASTYEAR. See example file attached. I hope that points you ...

Hi Eva, Your Slicers are connected to the original source data. If you created a new version of the data for your charts, then you need to start fr...