In this blog post, we’ll explore my solution to Problem of the Week #12. For this challenge, we revisited Enterprise DNA’s maiden Problem of the Week challenge, where we created a perpetual holiday calendar from a mix of specific and relative dates. But this time around, we will be using only Power Query. You can
We’re ending June with a bang by introducing a new course on the Enterprise DNA Education Platform — the 1st of many installments of the Power Query/M Masterclass. Those who will sign up for this course is in for a real treat because Enterprise DNA Expert Melissa de Korte will be hosting this class. Those
In today’s blog, I’m going to feature the solution to the Enterprise DNA Problem of the Week #9, including a simple and generalizable framework for incorporating M code into a Power Query custom column. You may watch the full video of this tutorial at the bottom of this blog. Being able to create columns in
In this tutorial, I’ll discuss distance calculation on map in Power BI based on forward stock location (FSL) and delivery point. This is just one of the various ways on how you can efficiently use distance calculation for geospatial analysis. In this example, I’ll display and analyze customers within a radius from an existing forward
For today’s blog, I want to discuss a not-unusual situation with many of my consulting assignments for the Canadian government, where my clients require all publications to be bilingual or available in both official languages, English and French. I’ll show you how I do a multilingual Power BI report for this tutorial. You can watch
