Forum

Hi Heleen, In the file attached I used Power Query to number grouped rows. I had to add Table.Buffer to the Sorted Rows step because the sort order...

Hi Robert, Welcome to our forum. It's not clear what you mean. Please upload a small sample file containing your data and desired result. Myn...

Hi Rosemary, I understand that the spaces in the middle of the text string can vary, but do they always have the same number of leading and trailin...

Hi Cathy, If your data is stored in an Excel Table then you should be able to Refresh All and have all PivotTables pick up the new data. Rather tha...

Hi Melissa, 1. To view the field list, right-click the PivotTable > Show Field List 2. Yes, just click the Refresh All button on the Data tab...

It doesn't matter what the location is of the source data, Excel Online has no refresh functionality, so the only option is to refresh from the deskto...

Hi MJ, Someone else asked this the other day. In Power Query you cannot establish whether a process is more or less efficient based on the number o...

Hi Madhuri, In Excel you can use this formula: =IF(J2="","",IF(J2>=H2,J2-H2)) In Power Query change the data type for the schedule start, ...

Hi Madhuri, Welcome to our forum! It's great to hear you're having some success building your own dashboards. The forum is here to help you if ...

Hi Victor, Welcome to our forum! Thanks for sharing your file. I was able to refresh the query without any issues. I suspect it may be something...

Hi Melissa, Yes, you need to unpivot your data, but this is easy with Power Query: You can then use Show Values as > Percentage of Parent Co...

Hi Bob, Welcome to our forum! It looks like cell names with workbook scope trump names with worksheet scope even though the hyperlink definition on...

Hi Diane, Welcome to our forum! We're not SharePoint experts here, but I'm pretty sure you have to give your users permission to the source data fi...

Hi Rosemary, Because your time series are going across columns, whereas mine were in the rows. It's therefore, giving you the total percentage chan...

Glad you figured out a solution. Your example data did not illustrate that the region could sometimes be in the middle, nor did you explain that in...