Tag: DAX

Highlight The Last Or Current Period In Your Power BI Visuals Using DAX

Posted on by Annie D

You can now add quite unique conditional formatting to visuals inside Power BI.

In this tutorial, I show you how you can combine DAX formulas with this new conditional formatting feature to highlight the last or most recent value in your visuals.

It’s a great technique that is very re-usable.

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

Calculating The Previous High Dynamically In Power BI Using DAX

Posted on by Annie D

In this unique example, we take a look at how you can calculate the previous highest result dynamically in Power BI using the right combination of formula techniques.

This is a great piece of analysis for many scenarios which is certainly worth reviewing and implementing in your Power BI models if it makes sense to.

Good luck understanding all the DAX logic behind 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

When To Use TOPN In Power BI – DAX Formula Review

Posted on by Annie D

TOPN is a great DAX function to use in Power BI when you have some internal ranking logic that you want applied to your calculation.

There are many occasions where there is a better formula combination to use than the alternative of RANKX.

There is a lot reviewed around this topic in the tutorial so 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

Effective Power BI Reporting for Analysts – Enterprise DNA Webinar Series

Posted on by Annie D

TO VIEW REPLAY & DOWNLOAD RESOURCE REGISTER HERE – https://ift.tt/30b1ET4

When is it?
July 3rd, 6pm New York (EDT), 3pm Los Angeles (PDT) , 11pm London (GMT) – July 4th, 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!

Why should I be there?
To learn how to develop compelling dashboards within Power BI using a range of analytical and visualisation techniques

What’s it all about?
We’ll be reviewing a number of techiques specifically around reporting dashboards in Power BI. Power BI is not just a visualisation tool, it is a powerful analytical engine that can produce amazing insights so I’ll be going over how you can combine both of these crucial elements to your reporting

View on YouTube

Iterating Functions Deep Dive – SUMX, AVERAGEX, MINX, MAXX

Posted on by Annie D

In Power BI you must understand the difference between aggregating functions and iterating functions very well.

In this tutorial we’ll be diving into iterating functions including SUMX, AVERAGEX, MINX & MAXX. Well be seeing the various ways they can be used and also going into detail how results are actually calculated when using these formulas.

These are some crucial concepts in Power BI when using DAX, so certainly dive into this content in detail and start practicing when you can using these techniques.

***** 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

Total Number Of Staff Over Time

Posted on by Annie D

In this example we are attempting to work out how many staff we have at any one time.

The technique discussed here are relevant for when you have a table with multiple dates in it and you need to run logic through that table to work out if an employee is still a staff member at any period of time.

This is also the technique to use if you want to showcase staff numbers or growth through time.

We utilise the correct relationship technique and also the ‘events in progress’ pattern to get this all to work successfully in Power BI.

***** 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 The Difference In Days Between Purchases Or Events In Power BI Using DAX

Posted on by Annie D

In this example I will show you how you can calculated the difference in days between purchases in Power BI using DAX formulas.

There is some advanced logic here using the FILTER and CALCULATE functions.

This is a great insights if you want to work out trends in customer behaviour or would like the target marketing campaigns more specifically to relevant customers.

Enjoy working through this tutorial.

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 The Occupancy Days Per Month In Power BI Using DAX

Posted on by Annie D

In this unique example, I will show you how we can dynamically show how many occupancy days per month in a matrix visual.

This is a great example of the power and simplicity of the DAX formula language. Where you can write a straight forward measure and extract some fascinating information and still be able to dynamically filter the data further to showcase varied insights seamlessly.

Enjoy working through this examples

Sam

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

FREE COURSE – Ultimate Beginners Guide To Power BI – http://bit.ly/2SGof6C

FREE COURSE – Ultimate Beginners Guide To DAX – http://bit.ly/2AyEb3P

FREE – Power BI Resources – http://bit.ly/2C2aBn3

FREE – 60 Page DAX Reference Guide Download – http://bit.ly/2AyEc7T

Learn more about Enterprise DNA – http://bit.ly/2RacRD3

Enterprise DNA Membership – http://bit.ly/2AAqa5u

View on YouTube

How To Manage Multiple Date Calculations In Your Fact Tables – Advanced Power BI

Posted on by Annie D

Managing multiple dates in your fact tables in Power BI can sometimes be very confusing when starting out in Power BI.

The idea behind this tutorial is to explain the logic and techniques required to get this working correctly in Power BI.

You need to get the right relationships and then use the correct DAX formula patterns when managing multiple date calculations.

Enjoy

Sam

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

FREE COURSE – Ultimate Beginners Guide To Power BI – http://bit.ly/2SGof6C

FREE COURSE – Ultimate Beginners Guide To DAX – http://bit.ly/2AyEb3P

FREE – Power BI Resources – http://bit.ly/2C2aBn3

FREE – 60 Page DAX Reference Guide Download – http://bit.ly/2AyEc7T

Learn more about Enterprise DNA – http://bit.ly/2RacRD3

Enterprise DNA Membership – http://bit.ly/2AAqa5u

View on YouTube

Calculate A Monthly Moving Average Year To Date (YTD) in Power BI Using DAX

Posted on by Annie D

In this tutorial we work through how you can calculate the year to date moving average of results in Power BI using DAX.

It is common to show the absolute YTD numbers but not the average YTD numbers, so it was a good opportunity to jump into the unique calculation and show you how it can be done.

Good Luck

Sam

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

FREE COURSE – Ultimate Beginners Guide To Power BI – http://bit.ly/2SGof6C

FREE COURSE – Ultimate Beginners Guide To DAX – http://bit.ly/2AyEb3P

FREE – Power BI Resources – http://bit.ly/2C2aBn3

FREE – 60 Page DAX Reference Guide Download – http://bit.ly/2AyEc7T

Learn more about Enterprise DNA – http://bit.ly/2RacRD3

Enterprise DNA Membership – http://bit.ly/2AAqa5u

View on YouTube

Calculate The Last Or Max Value Within A Table Of Data Using DAX In Power BI

Posted on by Annie D

In this tutorial we review how you can work out when the last value from a particular dimension in a table in Power BI.

This is quite a unique insight but a relevant one from many pieces of analysis that you might require in Power BI.

We work through examples of the MAXX and FILTER functions. These are two important functions in the DAX language that can be used in many situations to extract very interesting insights from your data.

Good luck.

Sam

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

FREE COURSE – Ultimate Beginners Guide To Power BI – http://bit.ly/2SGof6C

FREE COURSE – Ultimate Beginners Guide To DAX – http://bit.ly/2AyEb3P

FREE – Power BI Resources – http://bit.ly/2C2aBn3

FREE – 60 Page DAX Reference Guide Download – http://bit.ly/2AyEc7T

Learn more about Enterprise DNA – http://bit.ly/2RacRD3

Enterprise DNA Membership – http://bit.ly/2AAqa5u

View on YouTube

Detecting and Showcasing Outliers in Power BI – Enterprise DNA Webinar Series

Posted on by Annie D

Gain Access to Resource Download by Registering Here – http://bit.ly/2RplO8C

Workshop Session Topics:
– Creating scatter charts and breaking-out outlier results
– Comparing customers who are considered outliers versus those that aren’t
– Showcasing dynamically how outlier customer groups change over time
– Drilling down into what causes outliers through time

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

All Enterprise DNA TV Resources – http://bit.ly/2ZhmVtV…
FREE COURSE – Ultimate Beginners Guide To Power BI – http://bit.ly/2ESTLcy…
FREE COURSE – Ultimate Beginners Guide To DAX – http://bit.ly/2ESTLcy…
FREE – Power BI Resources – http://bit.ly/2ZfnaWh…
Learn more about Enterprise DNA – http://bit.ly/2RacRD3

View on YouTube