Forum

Hi Joseph, Yep, there are lots of ways to tackle some of the data cleaning exercises you might have. The purpose of lesson 6.11 was to teach error ...

Thanks, Paula. It took me a while to figure out which 'title' you were referring to but I think I've fixed it. Cheers, Mynda

Hi Paul, Are you able to share the file? There's not much we can do without seeing how it's constructed. If it's confidential then you can email...

Hi Amy, That's a great question. If you can tell me where you are I can put the word out to my fellow Excel MVP's and see if anyone is available to...

🙂 aw, thanks! Glad I could help.

Hi Euan, Thanks for taking the time to clearly describe your scenario. It made it easy to follow. Unfortunately there's no way to automatically ...

Hi Shelley, Great to see you're using the techniques. Are you able to share the file, or at least a screenshot. I'm trying to picture the gap is...

Hi Paula, Great question. You can certainly use Excel for filtering like this. However, one of the main benefits of using Power Query to get your d...

Hi Erwin, Pivot Charts have a bug where formatting is lost upon refresh. I suspect this is the culprit. The workaround is to create a regular ch...

Hi Paula, Initially there were two data catalogs in Power Query, one that was sharing corporate data and the other that had some free public data (...

Hi Moira, The LASTDATE function returns the last date in the data set in the current context. The last date in the Power Pivot model for session 10...

Hi Rob, Thanks for using the forum. In future please ensure you post your questions regarding courses in the 'Course Members Power Query Forum', no...

Hi Louis, First of all, thanks for using the forum. In future please post your course related questions in the Power Pivot Course Members forum, no...

Hi Marianne, When you import data the first step Power Query often applies is #Changed Type. It tries to identify the type of data you have in each...

Hi Divisha, You can use the NETWORKDAYS or NETWORKDAYS.INTL function to calculate the number of workdays excluding weekends. Mynda