Tag: Power Query

Perpetual Holiday Calendar – POTW #12 (Power Query Solution)

Perpetual Holiday Calendar – POTW #12 (Power Query Solution)

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

Continue reading

Power Query/M Masterclass #1 – New Course on Enterprise DNA

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

Continue reading

M Code In Power Query Custom Columns | Power BI

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

Continue reading

Distance Calculation On Map | Power BI Geospatial Analysis

Distance Calculation On Map | Power BI Geospatial Analysis

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

Continue reading

Create A Multilingual Power BI Report

Create A Multilingual Power BI Report

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

Continue reading