Forum

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

Hi Alicia, Great to hear you're enjoying the course! Thanks for sharing the link. You didn't say which tables you were planning on using from Qu...

Hi Anita, If you want a chart that includes AC1, AC2 and AC3, you simply select them in the PivotTable filter for the Channel Name. i.e. put the ch...

Hi Bax, Please see this tutorial on searching for text strings in Power Query. Hope that points you in the right direction. Mynda

Hi Alicia, Thanks for confirming it wasn't 5.04. I presume you meant 5.05 even though you wrote 5.04 again in your reply 😉 What I say in that ...

Hi Anita, Once you Close & Load the first time, the only place you can edit the load to settings is by right-clicking the query in the Queries ...

Hi Jennifer, Better to use a lookup (merge tables): Or you can use List Functions: Or if it's an approximate match: Mynda