Forum

Hi Saul, Welcome to our forum! You could store the time criteria in another table and do the equivalent of a VLOOKUP approximate match in Power Que...

Hi Nick, I recommend you use Excel Forms to gather the data. Hope that link points you in the right direction. Mynda

Hi Ed, This is a licensing limitation. The SharePoint Folder connector is only available in the standalone version of 2019 or with a Microsoft 365 ...

Hi Moriel, Please share an extract of your Excel file that illustrates the error. Mynda

Hi Lea, I think you've shared the wrong file as there are no cells in yellow. Mynda

Hi Glyn, Glad that helped. The 'values' field is automatically inserted in the PivotTable. It's usually in the Columns area, but I just dragged ...

Hi Glyn, I think I understand. In the attached file I've used calculated fields to create the PivotTable on Summary (2) sheet. Hope that's what ...

Hi Oswin, Yes you can use Power Query to get data from a specific sheet and table in each file in a folder. I recommend you change the file format ...

Hi Oswin, Welcome to our forum! When you close & load your query you can choose what sheet the table is loaded to. If you're still stuck, pl...

Hi Prasun, Thanks for sharing your file. Anders suggestion of custom data types was a good idea, but only available if you have Power BI and Micros...

Hi Thulasi, You need to add a calculated field that takes the balance minus the debit column first, then set this column to calculate as the runnin...

Hi William Instead of copying the chart and Slicer, try cutting them and pasting them on the sheet you want them on. When I did this there was no l...

Hi Glyn, Welcome to our forum! Your images didn't upload properly, so I'm not sure what they refer to and I can't see what the issue is in your fil...

Hi Gli, No file attached. You need to click the 'start upload' button after selecting your file. Anyhow, you can use the following formula to in...

Hi William, From my point of view your data is in the correct format, but as I don't really know what your expectations are I can't say much more o...