Tag: Power BI Query Editor

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

Power BI Map Visual: Creating A Custom Legend

Power BI Map Visual: Creating A Custom Legend

This blog post is about building a custom legend to replace the default legend in a standard Power BI map visual. The ArcGIS map visual is great. It takes some tweaking to get the most out of it, but it’s certainly worth your while. Just like other mapping visuals, the legend doesn’t look too good

Continue reading

Extract Values From Records And Lists In Power Query

Extract Values From Records And Lists In Power Query

In this blog post, we’ll take a look at how you can extract values from records and lists using Power Query. As you can see, the first column in my table contains records. You can watch the full video of this tutorial at the bottom of this blog. When I click off to the side

Continue reading

Power Query M: Alternating 0-1 Pattern In Date Table

Power-Query-M-Alternating-0-1-Pattern-In-Date-Table

This tutorial focuses on using the Power Query M number.mod function to create an alternating 0-1 pattern in the Date table. The solution that I’m going to show you came from one of our community power users, Rajesh, at Enterprise DNA. You may watch the full video of this tutorial at the bottom of this blog.

Continue reading

Power BI External Tools – Installing Practice Dataset

Power-BI-External-Tools-–-Installing-Practice-Dataset

I want to introduce you to one of the best Power BI external tools that Steven McGuire from the Enterprise DNA forum and I put together to help you with your structured practice. You may watch the full video of this tutorial at the bottom of this blog. I’ve talked a lot about structured practice,

Continue reading