Excel
How To Schedule Weekly Recurring Meetings across Multiple Timezones using Excel
When your team is distributed across the world, scheduling recurring meetings becomes a challenge because you need to cater for multiple timezones and daylight savings. That’s why I’ve created a spreadsheet template to make this process much easier. It’s not an app that automates the entire process, so you’ll still need to add the missing…
Read MoreDebugging DAX Formulas with Excel
Solving a problem in DAX can prove conceptually challenging due to the limited tools available to debug a formula. When you need to write a complex measure, you can write several measures, then combine them at the end into a single measure. However, what if you also want to inspect what rows are included in…
Read More