Forum

Hi Steve, This is the new Data Profiling information on data quality. You can expand the information via the View tab in the Data Preview group. Na...

Ah, now that you've provided a bigger screenshot I can see that the values in the TicketTime and NextTicketTime columns are the same, so you'll need t...

I'm not sure, Aye. I Googled the error and found this thread which might give you some ideas. If that's not it, then do another Google search and look...

Hi John, You just need to add a column that subtracts the TicketTime from the NextTicketTime. Mynda

Hi Alison, Your file mentions a 'split table' but you haven't included it so I can't show you an example. However, in session 7.08 of the Power Que...

Attached is an example file with a dummy data set, PivotTable, Chart and Slicer that will allow you to choose which country you want displayed in the ...

Hi John, You need a version of Excel with this feature. You can try updating Excel 2016 as some Power Query updates are provided, I'm just not sure...

Hi Howard, I think what we're all forgetting, me included, is that when you change the Sales value, so too does the Variable Costs value need to ch...

Hi Pakamon, Sure, can you please upload your sample Excel file so I can see how you're calculating the average. Mynda

Hi Howard, Have you tried using Goal Seek? I presume your sales figure is 'Turnover'. When you use Goal Seek to find where net profit = 0 it return...

Hi John, Thanks for joining my Power Query course. I'm sure you'll get a lot out of it. You can paste data to row 99 on Sheet 3 and it will be i...

Hi Saliha, It's not clear what you mean by 'use week instead of date'. The formula doesn't check for a date as such, it just checks to see if the c...

Hi John, I'd use Power Query to calculate the 'Minutes from Last Ticket' and then you can use the PivotTable to average. See Sheet2 of file attache...

Hi David, You'd need to change the update channel you're on to 'Targeted Monthly'. Mynda

Hi Steve, Password protected Access databases are not supported. Your only option is to insist IT remove the password protection. You can vote f...