Month: June 2021

Query Performance And DAX Studio Setup

This tutorial will discuss about setting up DAX Studio and measuring query performance in Power BI. These information will help detect bottlenecks in the query so that you can eliminate them and optimize your DAX. Setting Up DAX Studio Open the DAX Studio tool and connect your model. In this example, the EDNA Optimizing DAX

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

Power BI Heat Map: A Custom Visualization Tutorial

A Power BI heat map is a type of visualization that is used to show data density on a map. It is a graphical representation of data where the individual values contained in a matrix are represented as colors. In this tutorial, I’ll discuss how we can create a Power BI heat map using a

Continue reading