Forum

I'm a little confused. You say "I would like to categorize any respondent who chose either ADHD or OCD into Group 1, and respondents who chose anythin...

Hi Tony, It looks like this is a recent bug, as evidenced in the Microsoft Tech Community here: I am running version 1902 build 11328.20008 (Of...

Hi Katrina, I cover this in lesson 4.17 of the Power Query course. Have you watched that tutorial yet? Mynda

My pleasure, Tracy 🙂 It's great to have you join my courses!

My pleasure, Kaysar 🙂

For the benefit of others reading this, Kaysar emailed me his Excel file containing the model. It turned out that the Date table was not marked as 'Da...

Hi Kaysar, The screenshot omits essential details for me to understand what you're doing and how your model is structured. Are you able to share th...

Hi Bob, Unfortunately that's how PivotTables work. The workaround is to create a helper column that groups the dates and times into the increments ...

Hi Bob, I'm wondering why you can't just use OFFSET to derive the range. You've managed to get the cell addresses of the beginning and end cells, b...

Mmm, I just did a test and the file size reduced by about 16%. I've emailed Microsoft and I'll let you know what they say.

You're welcome, Luna. It's great to know I could help. I look forward to seeing you in my course 🙂

Hi Tracy, I made a few changes. See file attached. Mynda

Hi Kaysar, You simply cannot use time intelligence functions without a proper date field. I suggest you create a date field in a dd/mm/yyyy or mm/d...

Hmmm, maybe. It depends! This post has some information about how Power Query caches data, which is particularly important if you have queries referen...

Hi Anne, What version of Excel do you have? There have been performance improvements to Excel, but I'm not aware of anything that will make the fi...