Tag: Data Modeling in Power BI

Count Distinct Values In Excel: Classic To Modern Approaches

Count Distinct Values In Excel Classic To Modern Approaches

In this tutorial, I’m going to go through different approaches to how you can count distinct values in Excel from a more traditional way to a more modern technique. You can watch the full video of this tutorial at the bottom of this blog. I’ve got a list of names here, and I want to

Continue reading

Query Editor In Power BI | An Overview

WHAT'S POSSIBLE WITH THE QUERY EDITOR

In this tutorial, we’ll show a detailed example of why we always need to use the Query Editor in Power BI and what we can achieve when using it.  It’s deemed a best practice to always bring your data into the Query Editor first. We’ll show and prove it by running through some examples and

Continue reading

Power BI Dimensions & Groups For Filtering Tables In Reports

Power BI Dimensions & Groups For Filtering Tables In Reports

I want to show you a really simple, but super effective technique to create additional filtering or Power BI dimensions to filter by in your reports. You can watch the full video of this tutorial at the bottom of this blog. There are many places where you can add different dimensions. And when I say

Continue reading

Best Practices For Power BI Report Development

Best Practices For Power BI Report Developme

Over the last few months, I presented several tutorials, showcasing best practices for Power BI report development for each of the four pillars of Power BI. In this blog, I wanted to take this opportunity to present my personal top 10 list. You may watch the full video of this tutorial at the bottom of

Continue reading

How To Use Power BI VALUES Function (DAX) –  Enterprise DNA

VALUES-Function-DAX-In-Power-BI, values function (dax) in power bi post image

In this tutorial, I’ll discuss how the VALUES Function (DAX) allows you to create useful automation when working on a model with multiple date measures. You can watch the full video of this tutorial at the bottom of this blog. The VALUES function (DAX) returns a one-column table that contains the distinct values from the

Continue reading