Last seen: Jun 27, 2026
Hi Svea, Please upload a sample Excel file so we can understand what you're referring to. Thanks, Mynda
Hi Liam, I would use Power Query for this. In the file attached I loaded your data on Sheet1 into a table called Source Data. I then created a n...
Hi Alison, If you don't need to use any of the Time Intelligence functions and your reporting period is in line with the calendar year, i.e. not a ...
Yeah, I agree the ODC file method is more convenient when sharing with others. You could try creating it on a different PC to see if it's your PC caus...
Hi Stuart, Thanks for your detailed description of your process. I'm not sure why you're getting that error. Another option is to simply copy th...
Hi Lea, What do you mean by the connectivity file? Mynda
Hi Brian, If you use the Excel.Workbook(File.Contents( approach as shown in lesson 3.02, then when you expand the content column it will retain the...
Hi George, It can be caused when you don't choose 'organizational account' and your site is Office 365. The 'Windows' option is only for on premise...
Hi Dinesh, In the attached file I used the Excel Forecast Sheet tool to forecast your data as explained in this post: Note: I had to fix your d...
Hi Dean, It's tricky without a sample file but hopefully you can follow the attached file. You can use the List.Numbers function to create a lis...
Hi Caspar, I think there's some confusion about the process; when Power Query loads the data from the folder it takes one workbook as the sample. T...
Hi Karen, The options are merging and appending under the 'Combine' group. Append is effectively copying and pasting one query under another, ex...
Hi Spiros, You can use the PivotTable to do this for you. No need for SUMIFS. First you need to fix your date and time data because it's not in the...
Hi Michael, Correct, Power Query only imports the data that meets the filter criteria. i.e. you're reducing the data you bring into Excel so that o...
Hi Mark, Good question. No, not that I know of, but you can add a 'Title' to the table that clearly states the figures are averages. Mynda