Forum

Hi Moriel, I'm not sure what you mean by 'the calculations'? Are you saying in Power Query you can see results in the new columns, but when you clo...

Hmmm, I'm not sure why the data table doesn't follow the order of the series in the PivotTable. I assume it's because of the different chart types, bu...

Hi Erwin, You can manually sort by left clicking and draging the fields names into the locations you want in the PivotTable itself. Mynda

Hi Matt, The XLOOKUP formula finds the CRT to date, plus the average CRT to date * the remaining working days in the month. It's simply extrapolati...

Hi Kate, Welcome to our forum! You're right, you should not have your data in separate sheets for each month. You can use Power Query to gather the...

Hi Riccardo, Riny is expecting you to have used the technique shown in lesson 2.05 of the Power Query course. Have you tried that and then applied ...

Ah, that makes sense. I agree, one day's worth of values is not much to go on. Maybe you could leave the forecast blank until you have enough data.

Hi Matt, Change the formula in cell M2 to this: =XLOOKUP(C3,CRTData[Months],CRTData[Combined Running Totals],"")/IF(DAY(C3)=1, NETWORKDAYS.INTL(...

Hi Peter, You can use Incremental Refresh. Mynda

Thanks, Matt. I thought the attachment was going to be an Excel file. Can you please upload a sample Excel file containing your formula and the desire...

Hi Matt, No file attached. Please click the Start Upload button after selecting your file and wait for the grey check mark beside the file size bef...

Hi Carla, You can do this using the filter button drop downs on each column. Have you tried this? If you're still stuck, please provide a sample fi...

Hi Aiyah, I'm not familiar with SQL, sorry. However, once the query loads, you might be able to get the database name from the Source step of the q...

No need to create a group. Simply put the channel name in the filters area and use the drop down on the PivotTable to check the boxes for the items yo...

Hi and welcome to our forum! You can automate this with Power Query. Alternatively, you can probably use some more formulas to make things a bit le...