Forum

Great to see Sunny was able to help.

Great news, Blanka. Glad you have a workable solution and even better that Power Query was useful.

Hi Glenn, Which tutorial was this in, i.e. what number? Also, yes you can ask questions in the forum for the specific courses you're enrolled in...

Hi Nick, The Marketing Cost table Valerie is referring to is available in the Excel Dashboard course working files and it's my version of the Homew...

Hi Oleg, Why do you need a dynamic path to connect to your SQL server? Usually the server path doesn't change, unlike an Excel workbook. Ken Pul...

Very nice, Frans. Thanks for sharing. Mynda

Hi Gayle, A linked table will only be linkable to the Power Pivot model in the workbook in which the table resides. So you can either move your dat...

Yes, because when you choose an item in the Slicer it changes the PivotTable so if the PivotTable can't change it won't work.

Hmmm, PivotTable comes to mind, but like Frans says, a sample file will help us to help you further. Mynda

Hi Oleg, Great. I'm aiming for February. I'll be sure to let you know when it's ready. Mynda

Hi Anders, You can Merge Queries to achieve the same as VLOOKUP. See session 3.04 in the Power Query course. Let me know if you have any problem...

Hi Frank, Are the PivotTables that the Slicers are filtering in cells that are unlocked? Mynda

Hi Bill, Power Pivot is the same in Excel 2016 as it is in 2013 so I suspect you haven't enabled the Power Pivot add-in, or you don't have a versio...

Hi Robert, I just downloaded the workbook zip file from the course and all the files are there. If you go to the very first lesson you can download...

In that case I'd probably cheat and use a formula like this: =COUNTBLANK(B1:B9)-COUNT(A1:A9) Assuming column B is empty. In other words, coun...