Forum

Hi Murray, I suspect you are confusing merging with appending. Appending is similar to copying and pasting data sets one below another. For this th...

Hi Murray, Welcome to our forum! Yes, you can get data from a table that contains formulas with Power Query. Mynda

Hi Maarten, Thanks for the sample file. You need to also create the relationships between your CapacityWeek and CapacityMonth tables and the Cal...

Hi Maria, The WYSIWYG error is caused when you copy and paste text into the forum from another application, like Word. If you want to paste text, y...

Hi Guy, Welcome to our forum! I haven't seen that error before, but this post has some ideas and resources, including a video from Microsoft, wh...

Hi Briana, Print settings applied to a file are saved so others will automatically have those settings when they open the file. You can't copy prin...

Hi Maarten, You're on the right track creating a date table to facilitate relating the 3 tables. What is the issue with regards to creating a hiera...

Hi Jan, While it might appear to be working fine in Power Query, it's obviously filtering out the 2018 and 2019 data at some point. I'd step back t...

Hi Shabby, Your example isn't quite clear, but hopefully you can follow and modify the attached file if required. For the half years I used this...

Hi David, I recommend this VBA course. Hope that gets you started. Mynda

Nice modification, Jim! Thanks for sharing.

Hi Mei, Check your source data. Some of the months must have a space at the end of them or some other non-printing character that you can't see. If...

Hi Jim, You can use this formula by fellow Excel MVP, Ismael Romero: =UNIQUE(LET( ranges, (A2:A4,C2:C4,E2:E4), areas, AREAS((A2:A4,C2:C4,E2:E4))...

Hi Mei, Congratulations on your dashboard success! I'm not sure what you mean by your month Slicer duplicating months. Can you share a screensho...

Hi David, I'm not clear on whether the problem is getting the Mortality Table into Excel from an external source, or how to reference a Mortality T...