Forum

🙂 glad you're enjoying the course. Can't say I've ever heard of anyone learning Excel in the gym before!

Hi William, You can add a custom column that references the Date column in your data set using this formula (Change [Date] to match the name of you...

Hi William, Please see the file attached to see if that's what you had in mind. Note: I've put the two files into separate sheets in the attached f...

Hi Jeroen, Unfortunately, regular PivotTables and Power Pivot PivotTables won't show the months broken out for one aggregation method (sum) and not...

Hi Ian, Welcome to our forum. I'm not really sure what you're trying to do, sorry. I don't see any difference between the tooltips that appear when...

Hi Chris, You didn't provide a 'desired result' example, so I've guessed a little. See query 'Table1' and result on 'Sheet1' of the attached file. ...

Hi Andrew, It looks like your boss may have purchased a basic version of Office, because I can still see the Oracle connector and many more under D...

Hi Jan, I didn't suggest to use RELATED to bring in the patient numbers to another table, only for the rebate information. The patient numbers shou...

Hi Jan, In your case you will have two fact tables, one for costs and one for patients. Both will be related to a dim clinics table. You can refer ...

Hi Jan, Thanks for sharing your proper data. I see that you haven't unpivoted the Patients data i.e. you have 3 columns containing patient numbers ...

Hi Cheryl, If the error is about Power Query functionality then you can usually just ignore it and it will work fine. You can try uninstalling Powe...

Glad you got it working! It's always better when you figure things out for yourself...you're more likely to remember it then 🙂

Hi Jan, Thanks for the file. Unfortunately you can't use RANDBETWEEN to create the Clinic IDs and other dummy data that requires relationships as t...

Hi Wico, Welcome to our forum. Looking at the data, there's not much consistency that you can leverage to automate separating of the street numbers...

Hi Trevor, I misunderstood your process and to be honest, I still don't really understand it even with the M code, as it's very difficult to read t...