Tag: Power BI

Why Using Variables Is A Better Way To Write DAX Measures – Power BI Admin Advice

Posted on by Annie D

In this tutorial I run through an advanced formula and how I have used variables effectively to simplify the readability of the entire function.

I talk through why and when I decide to use variables extensively versus measure branching techniques.

In the example I’m working through the logic I included in a recent member-only event focused on project management analysis in Power BI.

Enjoy!
Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Create A Gantt Chart In Power BI With A Matrix Visual

Posted on by Annie D

In this tutorial, I will work through how you can create a Gantt Chart in Power BI using the matrix visual.

This is a very unique way in Power BI to create a visualization which represents time related information.

We work through how to create the right data model. The advanced DAX formula combination and also how to use conditional formatting inside the matrix visual.

Enjoy learning about Gantt Chart in this particular tutorial.

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

How To Use Iterating Functions To Solve Total Issues In Power BI – DAX Concepts

Posted on by Annie D

In this example I will show you how to solve issues with your total results by using simple iterating functions like SUMX in Power BI.

This is a very good review of how context works in Power BI. This is such a key concept to master when utilizing DAX formulas.

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Using The Performance Analyzer In Power BI – Model Optimization Tips

Posted on by Annie D

In this tutorail we are going to review the new Performance Analyzer feature in Power BI.

We will first review how it works and some of it’s functionality, then I will run through a few optimization ideas for your reports and formulas that should improve performance.

This is a fantastic new addition to Power BI, that will help if your models and calculations are running slow.

Enjoy!

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

How To Use The GROUPBY Function In Power BI – DAX Function Review

Posted on by Annie D

In this tutorial we will run through how to use the GROUPBY function in Power BI.

This is a similar table function to the likes of SUMMARIZE and SUMMARIZECOLUMNS, but it has some unique nuances to it that are interesting and worth diving into more deeply.

You can use the GROUPBY function in a few ways and I will look to show these to you during this particular video.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Custom Conditional Formatting For Power BI Tables

Posted on by Annie D

In Power BI we now have a wide variety of conditional formatting possibilites for tables. This wasn’t always the case.

During this tutorial I take you through a range of examples using conditional formatting rules in Power BI.

There is so much flexibility now to complete an almost unlimited amount of conditional formatting.

Enjoy!

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

How And When To Use COMBINEVALUES In Power BI – DAX Function Review

Posted on by Annie D

In this video we will be covering how and when to use the COMBINEVALUES DAX function in Power BI.

This is not a difficult function to use and is similar to the CONCANTENATE function in excel.

I run through a number of examples to give you a good idea of where this can be used effectively within your development.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Calculating Staff Turnover In Power BI Using DAX – HR Insights

Posted on by Annie D

Recently I created a tutorial around how to calculate the amount of staff an organization has at any one time.

From this I decided to also then calculate the staff turnover calculation.

When you can get both of these results onto one chart you can actually create some compelling insights in Power BI.

You can create to high-quality HR (Human Resources) insights with Power BI.

You’ll learn exactly how to do this within this particular tutorial.

Good luck

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Conditional Formatting For Chart Visuals In Power BI – What’s Possible?

Posted on by Annie D

In this tutorial I wanted to showcase to you some examples of how you can create custom conditional formatting within charts and visuals.

This is a seriously good addition to Power BI functionality, and I’m hoping to give you some inspiration here.

There are almost unlimited ways you can create insights within your visuals no using this feature.

A great video to work through. Enjoy.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

How To Use Virtual Tables With COUNTROWS in Power BI – DAX Formula Technique

Posted on by Annie D

In this example I want to expand you mind around the possibilities you have when using the COUNTROWS functions.

You are not just restricted to using COUNTROWS with a physical table. You can also use virtual tables that contain complex logic themselves.

This is a very good review of virtual tables in general and the flexibility you have in Power BI when you use them effectively.

Good luck

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Advanced RANKX – How To Understand This Function More Deeply

Posted on by Annie D

In this particular tutorial I’ll be diving into the RANKX function and how complex it can be at times.

By working through an example I hope that you can understand the many nuances to working with this particular function.

You first need a solid understanding of context and then also how to use RANKX within that context.

Enjoy!

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Logistics Insights For Power BI – DAX And Data Modeling Overview

Posted on by Annie D

In this particular example we will cover how you can solve for logistics insights in Power BI.

This has a lot to do with dealing with multiple dates in your fact table, then using the events in progress pattern with DAX.

This is a really good real-world application of a variety of Power BI techniques.

Enjoy working through this one.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube