Forum

Hi Fred, No need to simplify it. Just use the Filter drop down on the column to set your filters and let Power Query worry about the M code. Myn...

Well done, David! It's always more rewarding to solve it yourself 🙂 The I Simply Excel t-shirts are no longer available 🙁 You can usually get P...

Hi David, I think there are some details missing. Do you have a measure for the 'Total number of Time clock hours'? Is that returning the correct r...

Hi Philip, Yep, this has been superseded by Power Query 🙂 While you may have been able to install it, it's not supported for Excel 2016. My...

Hi Karen, The eBook gets sent to you 31 days into your membership. Do the course first, then use the eBook as a reference later on. No transcrip...

Hi Sarah, I can't use your file because the connection is external to the file and I don't have access to the original data. When I used the data l...

Hi Sandra, You need to click the yellow 'Start Upload' button to actually upload the file to the forum. Please post a screenshot of you right-cl...

Hi Sarah, You need to 'Change Type Using Locale' as covered in session 4.03 of the Power Query course. The locale will be English (United States). ...

Hi Karen, Glad you found a workaround while you get up to speed with Power Query. Yes, Power Query can concatenate rows. It requires you to tran...

Hi Sandra, I don't have enough information about where your data is coming from or how you are refreshing. If you click the 'Refresh All' button...

Hi Dave, Great to see you're back on the Excel wagon and making use of Power Pivot. You need to have a 'Date' or 'Calendar' table in your model....

Hi Sharleen, In session 3.05 I cover how to get data into Power Pivot from external Excel files. This way your data can be in a separate Excel...

Hi Sandra, 1. From what I've seen of your screenshots emailed last week, another option is if the dates in your top row are actual dates, and not t...

Hi Bjorne, Kind of - see file attached! You can create a scatter chart using the price and brand position values. Set the axes to start at 1. Th...

Sure, or pop on Dropbox. Whichever is easier.