Last seen: May 22, 2025
Hi Chris, Square brackets declare column names. You cannot change them to double quotes in the 2nd and 3rd arguments of the formula. The last argu...
Hi Thomas, Welcome to our forum! It's great to hear you found my videos helpful. You can use Power Query to automate the updating of your report...
Hi Chris, The null in your source data is not a true null value and it's part of the problem. First you need to remove the null from cell A11 in yo...
Hi Bruno, There's no way to refresh the data and not have it overwrite the previous query results. If you want to keep a copy of the data, then you...
Hi Paul, First, you need to put your data in a tabular layout. The data on the GP & Occupancy sheets is not in the correct format because it ha...
Hi Helen, Great question. There's no way to allow hover visibility in a protected worksheet/workbook. Best option is to give your colleagues access...
Hi Sunny, I don't think this is what Melissa wanted as she said: "I'm trying to capture the total "yes" responses for each option as well as the...
Hi Christoph, You can use the From Folder connector and then filter the list of files to only include the one you want to get the meta data from. ...
Hi Melissa, I've already given you the solutions to the DAX measure and age band grouping in the file I attached to my reply on November 17. As...
Hi Lesley, Welcome to our forum! Each year must be a separate series and you then set the series to 100% overlap. To achieve this, put each year...
Hi Michelle, If you look at the dates in the Actuals and Budget Excel Tables by selecting a cell and then viewing it in the formula bar, you'll see...
Hi Marko, Definitely better to have one big table with all your data, than split it into separate tables for each brand. Having separate tables for...
If you've pasted the data as values then the chart won't reflect any updates to the PivotTable, so not ideal as you'd have to copy and paste as values...
Hi Marko, No, the PivotTable will always display the prior period and the chart will always display the data from the PivotTable. If you add a Slic...
Hi Jet, Probably, yes. Just make sure your data is structured in a tabular layout and from there anything is easy. Mynda