Forum

Hi Max, I think your table is fine and you can enhance the filtering functionality with Slicers for Excel Tables. To fix the count information, you...

Hi Mattias, As Phil said, seeing your file would be easier. It looks as though you have a record in the source data table with no day name or time ...

You can't do this with this technique. If you add a filter (Slicer) for the year it will override the filter on the 'Include Years' column in the Pivo...

Hi Shawn, Please see this tutorial on how to calculate if dates fall between a date range. Mynda

Hi Mark, PivotTables sort by the first column. If you want to sort by date, put the date field in the first column of the PivotTable row labels. ...

Great to hear! Thanks for letting us know.

Hi Chris, Welcome to our forum! You can change the starting date formula to something more relevant to you. If you want the previous week and th...

Hi, please see an example file attached with a possible solution. Mynda

Hi Scott, Given that the position of the codes can be left, middle or right, I think you need to split the data into rows so you can compare them m...

Hi Casey, I'm guessing you can use Split by Delimiter once into columns for the separate columns and then into rows for the data. Then you can remo...

I'd ask the database administrator to write a view that you can connect to with Power Query. After all, you're getting the data via your legacy connec...

Glad you figured it out, Sherry! Thanks for sharing the solution.

Hi Carolyn, You can use this formula to return the value filtered by the Slicer (it will only return one value i.e. it cannot handle multiple value...

Hi Natasha, Welcome to our forum! If the file size is small and it's still slow then it sounds like there might be something corrupting the file. I...

Hi Alma, I'm not sure why changing workbooks would trigger this error, sorry. That said, I would not be using the legacy web connector. I'd try to ...