That’s great to hear, and is my hope for everyone participating regularly in Accelerator - that over time you’ll go back and revisit your earlier entries and find things that you struggled with at the time now look much easier. If that happens frequently, we’ll know this initiative is successful.
I’m away from my computer at the moment, so can’t send a screenshot but let me try to do it verbally.
Open the PBIX
Click on Transform to go into Power Query
On the left side, click on the relevant table
On the right side, double click the source step
This should bring up a dialog box from which you can change the source path
Do this for all tables needed
Click Close and Apply
Hi:
Can someone direct me to where the original Excel data for the week 1 is located?
Also, is it the case that to enroll in the Accelerator is an additional charge beyond the membership?
While I’m asking questions the intro post mentions a video to be posted. Where
would this be?
No, no additional charge – all Accelerator content and events are included in your Enterprise DNA membership.
As @Keith said above, the Excel file is not necessary for the Week #1 activity, but if you’d like to play around with it anyway, I have attached it below.
I am having an issue with the month & year sort order. I notice that when Sam drops total sales & month & year on the model it is sorted correctly, but when I do it I get an alphabetical sort Apr 2018, Apr 2019 … How can I solve this?