Tag: DAX

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

Cluster Analysis Visualization Techniques For Power BI – Power BI Review

Posted on by Annie D

In this break out session from a recent Enterprise DNA Learning Summit workshop, we are diving into how you can showcase data clusters in Power BI.

Not only this we are also showing how these data clusters change through time.

There are many DAX concepts and also visualization techniques discussed during this tutorial.

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

Time Based Cohort Analysis – How To Setup Your Data Model In Power BI

Posted on by Annie D

In this example we’re going to work through how you can create time based cohort insights within Power BI.

You need to get a number of development techniques right here to make it all work, including with the data model and also with your DAX formulas.

This is a break out session from a recent Enterprise DNA member only event.

Enjoy working through this advanced analytics example for Power BI.

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

Dynamically Group Receivables Based On When Cash Is Expected – Power BI Accounting

Posted on by Annie D

During this unique accounting focused example I’m going to showcase how you can create some incredible analysis of your receivables within your organization.

We are going to review some dynamic grouping formula techniques that I believe will amaze you in their ability to showcase information in new and interesting ways.

This scenario can also be referred to as an ‘aged trial balance’

This is also a short break out session from the financial reporting course now available at Enterprise DNA Online.

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 Unique Table Template Designs Within Power BI – Power BI & Financial Reporting

Posted on by Annie D

In this tutorial I will show you how you can create unique table templates for your Power BI reports.

This is a short break out session from the new Financial Reporting course available at Enterprise DNA Online.

This is a high quality visualization technique developed by Enterprise DNA.

Plenty to learn and implement during this one.

We cover the technique but also formula ideas using SWITCH/TRUE logic.

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

Calculate A Rolling Average In Power BI Using DAX

Posted on by Annie D

In this example I’m going to show you how you can create a dynamic rolling average in Power BI.

This is a unique formula combination that allow you to calculate an average result for any selections or context that you have inside your Power BI reports.

We dive into the AVERAGEX function during this one, which is a very useful iterating function.

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

Steps To Mastering Power BI & DAX

Posted on by Annie D

TO VIEW REPLAY & DOWNLOAD RESOURCE REGISTER HERE – https://ift.tt/2LINHHM

When is it?
July 10th, Wednesday – 6pm New York (EDT), 3pm Los Angeles (PDT), 11pm London (GMT)
July 11th, Thursday – 8am Sydney (AEDT), 10am Auckland (NZST)

Where is it? Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Sam McKay, Founder of Enterprise DNA – Driving an analytical movement through using Power BI!

During This Free Training, You Will Learn:

– The 4 Key Pillars To Any Power BI Development
– My Top, Best Practice Tips For Building Power BI Reports
– Showcase The Power Of The DAX Formula Language
– How To Combine Analytical Techniques To Solve Problems

If you have questions regarding this training, please send it at https://ift.tt/2xDKj94

View on YouTube

How To Create Unique Subtotals In Power BI Tables Using DAX

Posted on by Annie D

I wanted to show you in this tutorial how to create unique subtotals with Power BI.

This actually isn’t possible if you use just the out of the box table visual in Power BI. You need to use a combination of technique developed and refined by Enterprise DNA.

This is a seriously cool technique that opens up plenty of new visual possibilities in Power BI.

Enjoy learning about 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

The Main Difference Between ALL And ALLSELECTED – Power BI & DAX

Posted on by Annie D

During this video tutorial I run through the main difference between ALL and ALLSELECTED.

When first starting out with Power BI this can be relatively confusing so the idea here is to make this clearer in your mind when to use either in your Power BI reports and model.

Plenty to learn during this tutorial.

All the best.

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 Create A Dynamic Headings In Power BI Using DAX

Posted on by Annie D

In this tutorial I showcase how you can create dynamic headings or text inside of a Power BI report.

This technique is not to difficult it just requires a reasonable understanding of DAX and how to utilise it in Power BI.

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