Tag: DAX

Calculating Dynamic % Of Total Changes – Power BI Analysis w/DAX

Posted on by Annie D

Recently on the EDNA support forum, a member was stuck on how to work out the differences around percent of total calculations year to year.

There’s a much simpler and dynamic way this can be done.

In this tutorial, I run through the techniques required to make this all work in Power BI.

It’s much simpler than you think.

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

Discovering Advanced Insights w-Power BI – Enterprise DNA Webinar Series

Posted on by Annie D

TO DOWNLOAD RESOURCE REGISTER HERE – https://ift.tt/2I5zFxw

Workshop Session Topics:
– Advanced DAX formula techniques
– Measure Branching
– Time Intelligence calculations
– Moving Average formulas
– Cumulative Total formulas
– Visualization techniques
– and others

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

Where is it?
Join in from your laptop/desktop

How long is it?
Session will run for between 45 – 60 mins

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 harness the real analytical power behind Power BI.

View on YouTube

The Ultimate Budget Allocation Methodology For Power BI Analysis

Posted on by Annie D

When working on budget data inside Power BI you need to solve and manage data at different granularities.

In this video I work through the ultimate formula for allocating budgets to daily results.

I also work through all individual steps in the formula so you can see how it all works in together.

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

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?
September 4th, 6pm New York (EDT), 3pm Los Angeles (PDT), 11pm London (GMT)
September 5th, 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

Revenue Forecast Techniques For Project Data – Power BI Insights w/DAX

Posted on by Annie D

When working with project data in a lot of cases, you are dealing with information in the future.

In this tutorial, we work through how you can project revenue into the future based on future project data.

I showcase how to set up the model and also what DAX formulas to utilize to run this piece of analysis.

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

Calculate Days Of Zero Stock – Inventory Management Insights w/Power BI

Posted on by Annie D

Recently we had an interesting request on the Enterprise DNA Support Forum where a member needed to workout the number of days their inventory stock levels were at 0.

The technique required to work this out was unique because of the data set up that the member had.

Some different DAX formula techniques were used to solve this.

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

Enterprise DNA Learning Summit – August 2019, Optimizing DAX Formulas

Posted on by Annie D

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 6: Optimizing DAX Formulas

During this session we’ll be looking at a number of ideas around improving and optimizing DAX formula that you create. Enterprise DNA has a number of best practices around setting up your measures within your model.

We’ll be covering what steps you should take if you’re finding that your formulas are working very slow. Also, it’s important to gain an understanding of what certain functions are doing when used in combination with each other, so we’ll be reviewing many ideas here as well.

• Learn to structure your formulas correctly
• Master the proper syntax and best practices for measures
• Understand why your formula is working slowly
• Learn auditing techniques to optimize your measures
• Understands more deeply how formulas are calculated

View on YouTube

Enterprise DNA Learning Summit – August 2019, Budgeting Techniques

Posted on by Annie D

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 5: Budgeting Techniques

During this session, we’ll be covering a number of high-level budgeting concepts when working in Power BI. These techniques are some of the more advanced modeling and formula concepts that can be utilized in Power BI.

The key in this session is understanding how important it is to structure your model correctly to then simplify the formula logic that you need to write.

• Learn to deal w/ data at different granularity
• Manage a more complex data model
• Learn how to create virtual relationships using TREATAS
• Review Actuals vs Targets overtime

View on YouTube

Enterprise DNA Learning Summit – August 2019, DAX Formula Combinations

Posted on by Annie D

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 4: DAX Formula Combinations

When looking to scale your work in Power BI, you want to understand how you can reuse DAX formula combinations throughout your model. The speed in which you can create detailed analysis is significant when you utilize these techniques.

I will be covering techniques such as cumulative totals, grouping, averaging, and more.

• How to scale your development w/ DAX
• How to quickly create compelling analysis
• Analyze trends and time-based information
• Learn to re-use similar combinations of formula

View on YouTube

Enterprise DNA Learning Summit – August 2019, CALCULATE vs CALCULATETABLE

Posted on by Annie D

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 3 – CALCULATE vs CALCULATETABLE

With CALCULATE and CALCULATETABLE you have two of the most important functions in the entire DAX language. Understanding how these two functions operate is essential to any advanced analytical work in Power BI.

During this particular session, we will be drilling into the main differences between these two DAX formulas and also when it’s appropriate to use either one inside your calculated logic.

• Understand what CALCULATE does in-depth
• Start using CALCULATE correctly
• When to use CALCULATETABLE
• The main differences between these two functions

View on YouTube

Enterprise DNA Learning Summit – August 2019, DAX Fundamentals

Posted on by Annie D

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 2 – DAX Fundamentals

To harness the analytical power behind Power BI, you really need to master DAX. DAX is the formula language which enables you to discover incredible insights into your data.

Throughout the session, we’ll be diving into some initial key concepts that you certainly will want to understand thoroughly when creating reports with Power BI. These include topics such as iterating functions, context, and measure syntax to name a few.

• Review the concept of context
• Iterating vs Aggregating functions
• Understand how DAX works w/ the data model
• How to structure and organize your measures

View on YouTube

Enterprise DNA Learning Summit – August 2019, Data Model Design Best Practices

Posted on by Annie D

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 1 – Data Model Design Best Practices

During this first session, we will be covering aspects of data modeling when working with multiple tables. Getting your model set up correctly in Power BI is absolutely essential to creating a scalable solution.

Enterprise DNA has many best practices to utilize in this particular area. Ideas around how to structure your model and also how to connect the right relationships between your tables.

• Learn how to optimize data
• Setup data model structure
• Relationship best practices
• Unique data model designs
• Working w/ multiple tables

View on YouTube