Forum

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 ...

Yes, please send it to website at MyOnlineTrainingHub.com

Hi Lea, Excel.CurrentWorkbook requires the data to either be in a Table or named range. It cannot see unnamed data. If you don't want to name the d...

Hi Andy, Probably. Post your question and VBA code and file in our VBA forum where someone can help you. Please also advise them that you have cros...

Dynamic Array functions do not work inside Tables. Remove the Table formatting and use regular cells when working with dynamic arrays. You can use ...

Hi John, Try this: in the Power BI service click on the cog icon in the top right > Admin Portal > Tenant settings > scroll down to 'Integ...

Hi Philippe, In the top left of the Error Checking dialog box it tells you the cell with the problem. You can also click on Edit in Formula Bar and...