Tag: DAX

How To Use Variables In DAX Formula With Power BI [2023 Update]

Posted on by Annie D

Learning how to use variables in DAX formulas is beneficial for data analysts because it allows them to simplify their code and make it easier to read and understand. Variables can be used to store intermediate results, making complex calculations more manageable and reducing the risk of errors. Additionally, using variables can help to optimize query performance, as calculations that are reused multiple times can be cached in memory.

Using variables can make it easier to debug code, as it allows analysts to isolate and test individual parts of the calculation. In this tutorial, Sam will demonstrate how you can Continue reading “How To Use Variables In DAX Formula With Power BI [2023 Update]” →

Organize your DAX measures

How To Organize Your DAX Measures in Power BI Folders and Make Finding Them A Breeze

Posted on by Bb

As you progress in Power BI, you will gradually be working with more DAX measures and calculations. As a result, things can easily get cluttered. Today you will learn a few valuable tips and tricks on how to organize your DAX measures for a more efficient workflow. Hopefully this will help you and become a standard practice!

Watch the video for step by step instructions and a full explanation.

To summarize, Reid shows us how to add a new table and move our measures to it so they are together in one place.

He then shows us how to convert this into a folder, and then subsequently create subfolders to further organize your DAX measures in the model. Reid continues on to show us how we can have a measure in multiple locations if it makes sense.

What a great way to manage the measures as they grow in number!

***** Video Details *****
00:00 Introduction
00:33 Root folders
01:32 Subfolders
03:30 Actual Amount VTB

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial

Enterprise DNA Learning Summit – November 2019, Developing Enterprise Apps

Posted on by Annie D

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

Session 4 – Developing Enterprise Apps

The Power BI Online Service has gone through a huge upgrade recently and finally, there is a lot more clarity around how each different feature should be used. During this workshop, we’ll cover how to create compelling apps for your teams and organisations. We’ll also go over many of the new and interesting upgrades that have been created in the web-based platform for Power BI.

• Learn how to build effective app workspaces
• Scale the Power BI online service within your teams
• Manage multiple different reports and insights effectively
• Refresh your enterprise distribution strategies for insights

View on YouTube

Enterprise DNA Learning Summit – November 2019, Ranking Insights Tips

Posted on by Annie D

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

Session 3 – Ranking Insights Tips

Using either RANKX or TOPN in Power BI enable some fantastic insights. During this workshop we’ll be running through many variations where you can utilize these DAX functions to enable great analysis. Covered will be the key differences but also the best times to use each of these ranking formula concepts.

• Learn the versatility of ranking formulas with DAX
• Understand the possibilities with ranking functions
• Delve into the nuances of these important functions
• Create unique visualisations with ranking techniques

View on YouTube

Enterprise DNA Learning Summit – November 2019, Virtual Table Exploration

Posted on by Annie D

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

Session 1 – Virtual Table Exploration

During this first session, we will be exploring what virtual tables are in Power BI and how you can use these effectively to discovered advanced insights very fast. This is a very unique topic that will take you Power BI development to the next level if you can understand it well.

• Understand what virtual tables are in Power BI
• Create dynamic data groups within formulas
• Discover advanced insights fast with DAX
• Explore the limitless possibilities with virtual tables

View on YouTube

Upcoming Enterprise DNA November 2019 Learning Summit – What You Will Learn

Posted on by Annie D

FOR MORE DETAILS CLICK HERE – https://ift.tt/2q8z6Ni

Details of what will be covered below

Session 1 – Virtual Table Exploration

– Understand what virtual tables are in Power BI
– Create dynamic data groups within formulas
– Discover advanced insights fast with DAX
– Explore the limitless possibilities with virtual tables

Session 2 – Dynamic Grouping Concepts

– Learn why you should use this analytical technique
– Discover new ways to create groups for your data
– Uncover valuable insights using these ideas
– Group various dimensions from your data model effectively

Session 3 – Ranking Insights Tips

– Learn the versatility of ranking formulas with DAX
– Understand the possibilities with ranking functions
– Delve into the nuances of these important functions
– Create unique visualisations with ranking techniques

Session 4 – Developing Enterprise Apps

– Learn how to build effective app workspaces
– Scale the Power BI online service within your teams
– Manage multiple different reports and insights effectively
– Refresh your enterprise distribution strategies for insights

View on YouTube

Power BI & DAX Master Class – Advanced Analytics w/Power BI

Posted on by Annie D

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

When is it?
October 16th, 4pm New York (EDT), 1pm Los Angeles (PDT), 9pm London (BST)
October 17th, 7am Sydney (AEDT), 9am Auckland (NZDT)

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:

– Use DAX to create valuables insights
– Learn how to think creatively about what you can analyze
– Bring your analysis and visualization techniques together
– Create compelling reports and dashboard that add value

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

View on YouTube

Power BI & DAX Master Class – DAX Formula Combinations

Posted on by Annie D

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

When is it?
October 15th, 4pm New York (EDT), 1pm Los Angeles (PDT), 9pm London (BST)
October 16th, 7am Sydney (AEDT), 9am Auckland (NZDT)

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:

– Learn how to combine many different DAX functions together
– Solve unique analytical scenarios with DAX patterns
– Understand how to use the CALCULATE statement
– Master ‘measure branching’ techniques

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

View on YouTube

Power BI & DAX Master Class – Fundamentals of DAX

Posted on by Annie D

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

When is it?
October 14th, 4pm New York (EDT), 1pm Los Angeles (PDT), 9pm London (BST)
October 15th, 7am Sydney (AEDT), 9am Auckland (NZDT)

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:

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

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

View on YouTube

Power BI & DAX Master Class – Data Model Design Deep Dive

Posted on by Annie D

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

When is it?
October 13th, 4pm New York (EDT), 1pm Los Angeles (PDT), 9pm London (BST)
October 14th, 7am Sydney (AEDT), 9am Auckland (NZDT)

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:

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

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

View on YouTube

Actuals vs Budgets – Comparison Insights w/Power BI

Posted on by Annie D

In this tutorial, I run through how you can compare actuals to budgets in Power BI.

This is an extension of a prior tutorial that covers how to create the ultimate budget calculation with DAX.

***** 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 Total CRM Forecasts From Today Until End Of Month

Posted on by Annie D

In this video tutorial, I showcase how you can work out a dynamic monthly calculation.

This is perfect for a CRM scenario where you may want to dynamically calculate a monthly sales forecast for the remainder of the month.

In this example, we use the DATESBETWEEN function, which enables us to open up a dynamic date window.

Enjoy working through this one.

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