Forum

Hi Saliha, You can use COUNTIF to add a count of the B/e No records and then use a PivotTable to get your layout. See attached. Mynda

Hi Moriel, As I mentioned, I can't open your queries and you haven't said which columns you've added, but if I look at the tables in Power BI and s...

Hi Jacqui, You can protect the sheet objects (charts, images etc.). By default all objects are locked, you just need to enable the protection on th...

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...