How To Use The Enterprise DNA Support Forum

Detailed below are a range of tips for getting the most out of the Enterprise DNA Support Forum.

This forum is to provide support for all Enterprise DNA members. Currently, the forum is also read-only for any non-members.

Members can ask anything about Power BI or around the courses and content produced by Enterprise DNA and we will look to find a solution for you. Please review all the tips and rules around asking questions.

PLEASE NOTE - This forum is public. No information or data should be shared if it is considered sensitive.

TABLE OF CONTENTS

1. HOW TO GET STARTED WITH THE SUPPORT FORUM
2. HOW TO SEARCH FOR CONTENT WITHIN THE FORUM
3. TIPS FOR ASKING QUESTIONS IN THE FORUM
4. TIPS FOR ANSWERING QUESTIONS IN THE FORUM
5. HOW TO COMPLETE A FORUM THREAD

Advanced RANKX - How To Understand This Function More Deeply
How To Create Unique Subtotals In Power BI Tables Using DAX
Cluster Analysis Visualization Techniques For Power BI - Power BI Review
Conditional Formatting For Chart Visuals In Power BI - What's Possible?
How And When To Use COMBINEVALUES In Power BI - DAX Function Review
How To Use The GROUPBY Function In Power BI - DAX Function Review
How To Use Iterating Functions To Solve Total Issues In Power BI - DAX Concepts
Why Using Variables Is A Better Way To Write DAX Measures - Power BI Admin
Show Cumulative Totals Unaffected By Date Slicer Selection In Power BI
Using ALLEXCEPT To Stop Cumulative Total From Resetting - DAX Solution
Calculate Days Of Zero Stock - Inventory Management Insights w/Power BI
Revenue Forecast Techniques For Project Data - Power BI Insights w/DAX
Calculate Total CRM Forecasts From Today Until End Of Month - DAX Insights
Actuals vs Budgets - Comparison Insights w/Power BI
Calculating Dynamic % Of Total Changes - Power BI Analysis w/DAX
Using The Performance Analyzer In Power BI - Model Optimization Tips
Calculating Staff Turnover In Power BI Using DAX - HR Insights
Dynamically Group Receivables Based On When Cash Is Expected - Power
Custom Conditional Formatting For Power BI Tables
Time Based Cohort Analysis - How To Setup Your Data Model In Power BIn
How To Use Virtual Tables With COUNTROWS in Power BI - DAX Formula Technique
Create Unique Table Template Designs Within Power BI - Power BI &
Calculate A Rolling Average In Power BI Using DAX
How To Create A Dynamic Headings In Power BI Using DAX
Advanced RANKX - How To Understand This Function More Deeply
The Main Difference Between ALL And ALLSELECTED - Power BI & DAX
Highlight The Last Or Current Period In Your Power BI Visuals Using DAX
Calculating The Previous High Dynamically In Power BI Using DAX
When To Use TOPN In Power BI - DAX Formula Review
Inventory Management Development
Segment Data Based On Percentage Groups - Advanced DAX In Power BI
Report Design And App Navigation: Wrap Up And Last Tips
Creating A Report Navigation Using Unique Icons And Bookmarks
Colour Palette & Best Practice Visualization Techniques
Simple Visualization Tips
Ranking Formula Techniques
Unique DAX Formula Combinations
Bring It All Together Showcasing Key Revenue Insights
DAX Formula Implementation
Dynamic Visualization Techniques
Visualization Options
Advanced Dynamic Grouping Modelling And Formula Techniques
Initial DAX Formula Requirements
Modelling Considerations
Reviewing Receivable Reconciliations
Creating Visuals When Dealing With -Ve Numbers
Breaking Out Key Summary Lines Into New Tables
Utilizing Switch/True Formula Techniques
Calculating The Correct Summary Totals
Creating Initial DAX Functions For Report Breakdown
Creating Summary Table Of Key Financial Ratios
Dealing With Unique Table Designs And Summary Calculations
Using Switch/True Logic For Template Design
Calculating Subtotal Amounts
Managing Data At Different Granularities
Other Template Calculation Possibilities
Time Comparison Calculations
Options For Template Designs And Visuals
Overlay Main DAX Formula Combination To Template Design
Embedding Financial Template Design Into Report Page
Creating Rollup Subtotals Calculations
Dealing With +Ve/-Ve Numbers
Initial DAX Calculations
Creating The First Dax Formulas For Your Model
Organizing Your Model Well
Integrating Tables Together
Developing Your Data Model & Creating The Right Relationships
Financial Reporting Data Structure Tips
Query Editor Clean Ups And Transformations
Bringing Data Into Your Model
Planning Your Data Model
Power BI Model And Raw Data Review
Course Introduction: Financial Reporting W/Power BI
Dynamic Ranked Lists
Customer Attrition
Advanced Power Bi Analytical Techniques - Pareto Rule
Secondary Table Logic
Threshold Triggers & Breaches
Customer Segmentation
Pattern Recognition
Cross-Sell Opportunities
Outlier Detection
Cluster Analysis
Anomaly Detection
Running Sensitivities On Multiple Scenarios
How To Visualize Scenario Analysis Results
Solving For The Most Optimal Outcome
Iterating Through Numerous Scenarios
Scenario Sequencing - Maintain A Table Of Scenarios And Integrate All Values
Running Multiple Scenarios At One Time
Combining The Power Of The Data Model With Scenario Analysis
Extending & Branching Out Scenario Analysis
Comparing Scenarios To Budgets Or Forecasts
Project Numbers Forward Using New Tables Of Data
Project Numbers Forward With Time Intelligence Dax Techniques
Representing Changes To Your Variables
Integrating 'What If' Parameters
Nuances Of Setting Up DAX Measures
How To Really Predict The Future With Scenario Analysis Techniques
How To Implement It With 'What If' Parameters
Thinking Analytically About What You Want To Acheive
What Is Scenario Analysis?
How To Reduce The File Size Of Your Models
How You Can Improve Your Models
Active Vs Inactive Relationships
Multi Layered Models
Adding Dimensions To Lookup Tables
Scenario Tables ('What If' Parameters)
Supporting Tables
Intermediary Tables
Measure Tables / Groups
What To Do If You Don'T Have A Lookup Table
Setting Up Complex Models
Best Practice Tips For Setting Up The Data Model
What Are We Trying To Achieve With The Data Model?
Bringing Advanced Transformations Together
Custom FunctionsCustom Functions
Creating And Using Parameters
Custom & Conditional Columns
Columns From Examples
Unpivoting Your Tables
Merging Or Joining Your Queries
Appending Queries
Referencing & Duplicating Queries
Staging Queries
Creating And Modifying A Date Table
Filtering Tables For Unrequired Data
Row Transformations
How To Fix Things If They Fall Over In Here
How To Bring In Data To The Query Editor
Management Dashboard Intro
Scenario Analysis Development
Retail Sites Intro
Inventory Management Intro
Relative Distinct Counts Explained
Column Transformations
How To Organize The Query Editor Well
Understanding M Code
Tips And Techniques To Work Through In The Query Editor
What'S Possible With The Query Editor
Why You Always Need To Use The Query Editor
My Best Practice Tips For The Query Editor & Data Model
Insurance Applications Development
Insurance Applications Intro
Employee Insights Development
Employee Insights Intro
Management Dashboard Development
Scenario Analysis Intro
Retail Sites Development
Customer Deep Dive Development
Customer Deep Dive Intro
Consumer Goods Sales Development
Consumer Good Sales Intro
Dashboarding & Data Visualization Intensive: How To Approach
How To Create A Colour Palette That Wows Fast
My Visualisation Guide And Best Practices
Introduction To Dashboarding & Data Visualization Intensive
Fixing Errors With Parameter Tables
Extending Parameter Tables
Introduction To Parameter Tables
Extending Forecasting Models
Introduction To Forecasting
Extending Budgeting Models
Introduction To Budgeting
Sales And Orders In Progress
Dynamically Group Customers By Ranking
Dynamic Grouping Via Support Tables
Grouping Via Lookup Table Logic
Grouping Via Calculated Columns
Time Intelligence - Using Dateadd
Percentage Change On Prior Period
Time Intelligence - Measure Branching
Time Intelligence Aggregations
Cumulative Totals - Measure Branching
Cumulative Totals - ALLSELECTED
Cumulative Totals - ALL
Re-Using The Moving Averages Pattern
Moving Averages - Simple
Percent Of Total - Context Considerations
Percent Of Total - Simple
Advanced Table Functions: CROSSJOIN
Information - Openingbalancemonth, Startofmonth, Endofyear
Advanced Table Functions: SUMMARIZE
Advanced Table Functions: SELECTCOLUMNS
Why You Must Have A Date Table
What Are Time Intelligence Functions
Averages Per Day Examples
Table Functions: VALUES/HASONEVALUE
Table Functions: ALL
Advanced Table Functions: ADDCOLUMNS
Example Of Real World Situations Where You Would Use Time Intelligence Functions
Time Comparisons - Sameperiodlastyear, Parallelperiod, Previousmonth
Aggregations - YTD, QTD, MTD
Types Of Time Intelligence Functions
The Importance Of Context And The Calculate Function
How To Set Up Your Data Model
Moving Averages Examples
Cumulative Totals Examples
Table Functions: USERELATIONSHIP
Table Functions: ALLEXCEPT
Table Functions: ALLSELECTED
Table Functions: FILTER
Understanding Context Transition
Filtering With Calculate
Calculate Examples
How Are Formula Calculated When You Involve Calculate
What Can You Do When You Use Calculate
Why Do You Even Have To Use Calculate?
Why Calculate Is Important
Related Function
Isfiltered / iscrossfiltered
How Filter And Row Context Work With Relationships
Calculated Column Examples
Getting Started With DAX: IF
Sumx/averagex/minx/max
Getting Started With DAX: DIVIDE
Count/counta/countrows/countblank
Filter Propagation
Row Context Intro
Filter Context Intro
Evaluation Context
How The DAX Calculation Engine Works
Understanding Context
Lookup Tables Vs Fact Tables
How To Build Data Models So That DAX Actually Works As Expected
Working With One Table Versus Many Tables
DAX Patterns Intro
Calculate Function
Table Functions
Iteration Functions
Aggregation Functions
DAX Function Types
The Only Way To Learn Is To Practice On Variety Of Data Scenarios
DAX Doesn't Work Unless Your Data Model And Relationships Are Built Correctly
Writing Comments In Your Code
Formatting DAX Code
The Importance Of Naming Conventions
What You Can Achieve With DAX
How To Learn DAX
Mastering DAX Calculations: What Is DAX?
Mastering DAX Calculations: Formula Syntax
How To Understand DAX
Data Types And Operators
Power BI Desktop Features Explained
Key Components Of Power BI
Creating a Custom Sort Order for Month Due to Financial Years
Calculate A Monthly Moving Average Year To Date (YTD) in Power BI Using DAX
Data We Will Be Using For All Our Examples
What Is A Data Model?
Power BI Online Service Features Explained
Where Has Power BI Come From?
Current Pricing And Purchasing Considerations
Iterating Functions Deep Dive - SUMX, AVERAGEX, MINX, MAXX
Calculate The Occupancy Days Per Month In Power BI Using DAX
How To Manage Multiple Date Calculations In Your Fact Tables - Advanced Power BI
Calculate The Last Or Max Value Within A Table Of Data Using DAX In Power BI
Cumulative Totals Only Up To Specific Dates - DAX Tutorial For Power BI
Grouping Results Based On Performance vs Benchmarks - Power BI & DAX
Cross Selling Matrix Deep Dive - Power BI & DAX Tutorial
Showcasing Growth Performance Effectively In Power BI - Advanced DAX
How To Create Compelling Colour Palettes In Power BI
Power BI Report Design Tips And Best Practices
How To Setup Application Like Reports - Power BI Reporting Techniques
Reporting Templates Expanded - Power BI Visualization Concepts
Visualization Tips For Key Business Performance Indicators & Trends -
Show Actual Results vs Targets Only To Last Sales Date - DAX Cumulative Totals
Budgeting Performance Segmentation - Analytical Technique For Power BI Using DAX
Different Ways You Can Use The TOPN Function - DAX In Power BI
What Can You Do With Iterating Formulas In Power BI - DAX Review
Implement Cohort Analysis Within Power BI - Advanced DAX Concepts
Automated & Dynamic Financial Reporting w/Power BI
How And When To Use PARALLELPERIOD In Power BI - DAX Function Review
Monthly Budgeting Sensitivity Table Allocations - Power BI & DAX Analysis
Showcase Movement Within Custom Segments Through Time - Advanced Power BI
Show Difference To Forecast Up To Last Sale Date Only - DAX Technique In
Allocating Results To Pre-Determined Templates - Fnancial Analysis In Power BI
Who Are The Lost Customers - Advanced Analytics With Power BI & DAX
How To Download Latest Exchange Rates Into Your Power BI Model
Reviewing Customer Performance Over Time - Power BI Insights
How Does Sensitivity Analysis Work In Power BI - DAX Analytical Techniques
Profit Prediction Techniques in Power BI - Scenario Analysis w/DAX
Re-Using Moving Averages - Power BI & DAX Trend Analysis Technique
Creating Compelling Dashboards With High Quality Insights In Power BI
Creating Great Color Palettes for Power BI - Data Visualization Tips
Allocating Detailed Monthly Budgets Or Forecasts In Power BI Using DAX
Cumulative Totals Deep Dive - Power BI & DAX Formula Review
Integrated Financial Reporting - Power BI Techniques For Accounting &
Best Practice Tips For Organizing Your Power BI Models
When And How To Use The EARLIER Function In Power BI - DAX Concepts
Calculate A Reverse Cumulative Total In Power BI Using DAX
Aged Trial Balance Grouping Examples In Power BI - Business Analytics With DAX
How To Create Tables Combining UNION & ROW Function - Power BI & DAX
Creating Virtual Relationships Using TREATAS - Advanced Power BI Technique
How To Calculate A Cumulative Run Rate In Power BI Using DAX
Showcase The Top Result Name Within A Card Visualization - Power BI Technique
Calculate The Total Of Average Results In Power BI Using DAX
Calculate The MEDIAN Value In Power BI - Statistical Analysis w/DAX
Placing Workday and Weekend Day Numbers Into The Date Table - Power BI Time
Show Last N Sales Of A Customer Only - Advanced DAX Technique Using TOPN
Show Days Before Or After A Selected Date -Advanced Power BI Visual Techniques
Dealing With Products That Have Changing Prices - Power BI Analytical
Normalizing Results On Different Days - Time Related Analysis In Power BI
Normalizing Results On Different Days - Time Related Analysis In Power BI Using
Using SWITCH True Logic In Power BI - DAX Concepts
Dynamically Drill Into Your Top 20% Of Customers - Power BI & DAX Technique
Evaluating New Customer Sales - Advanced Analytics in Power BI
How Many New Customers Do You Have Each Month - Advanced Power BI Analytics
Data Setup Tips For Financial Reporting - Power BI
Creating PnL Statements In Power BI - Financial Reporting Example
What Is The First Product A Customer Purchased? - Power BI Analytics
How Many Customers Have Multiple Product Purchases - Power BI & DAX Analytics
Break Out Outliers & Analyze Over Time - Advanced DAX Concepts
How To Use The INTERSECT Function - Power BI & DAX Tutorial
Dynamic Results vs Budgets & Last Year - Power BI Financial Reporting Techniques
Project A Current Trend Forward Repeatedly - Forecasting Techniques, Power BI
Find Weekday & Weekend Day Numbers Within Months - Advanced DAX
Compare Current Sales To Previous Best Month - Advanced Time Intelligence In
When To Use The CALCULATABLE Function - DAX Function Techniques
How To Use The TREATAS Function - Power BI & DAX
Create An Entirely Dynamic Report In Power BI - Advanced Visualization Technique
Shape Map Visualization - Power BI Visual Techniques
Create Background Design Plates For Your Power BI Reports
How To Get Custom Icons Into Your Power BI Reports
Analytics Function For Power BI Scatter Charts Review
Designing Reports For Mobile Devices..Use This Feature in Power BI
Data Bars in Table Visualizations - Significant Viz Update in Power BI
Changing The Interactions of Your Visuals in Power BI
Developing Compelling Power BI Reports & Dashboards - Power BI & DAX
Visual Examples For Showcasing Sales Performance In Power BI
Considerations For Dark Backgrounds In Power BI Reports
Multi Measure Dynamic Visuals - Data Viz Technique In Power BI
Creating Dynamic Commentary in Power BI
Develop Compelling Visualizations Using Filter Fields & Visual Interactions in
Grouping & Segmenting Your Data With DAX Measure Logic
Detailed Banding & Segmenting Example in Power BI using DAX
Multi Threaded Dynamic Visuals in Power BI - Advanced Power BI and DAX
Cumulative Totals Across Averages & Dynamic Date Logic - Advanced DAX
Fixing Complex Total Errors - DAX Formula Concepts
Create Cumulative Totals, No Date, No Index - Advanced DAX Techniques in Power
Create Custom Dynamic Groups In Power BI - Advanced DAX
Dynamic Ranking Tables In Power BI - DAX Formula Review (RANKX)
Dynamically Change Size Of Visual Based On Ranking Selection in Power BI using
Combining Dynamic Grouping With Additional Ranking Logic with DAX
Understanding Anomalies with DAX in Power BI - Analytical Technique
Secondary Table Logic Inside Of Power BI Using DAX
Getting Started With 'What If' Paramaters - Scenario Analysis Techniques
Segmenting Dimensions Based On Ranking w/DAX in Power BI
Isolate Your Top Salespeople For Growth In Margins - Power BI & DAX
Threshold Triggers in Power BI using DAX - Advanced Technique
Create Dynamic Visuals Based on Ranking in Power BI wDAX
How To Discover Clusters In Your Datasets Using DAX in Power BI
Find Patterns In Your Data With Internal Logic using Power BI & DAX
Predict Profitability For Future Time Periods - DAX & Power BI
'What If' Sensitivity Analysis in Power BI using DAX - Advanced Technique
Run Scenarios On Changes To Your Average Order Size in Power BI w/DAX
Layering Multiple 'What If' Scenarios In Power BI - Advanced DAX Concepts
Extending Layered Scenario Analysis Techniques - Advanced DAX & Power BI
Complex 'What If' Analysis Example In Power BI Using DAX
Sensitivity Analysis In Power BI Using DAX
Multi-Layered Scenario Analysis using DAX in Power BI
Compare One Sale Versus The Last Sale (No Time Intelligence) - Advanced DAX
Showcasing Deviations Effectively In Power BI - Analytical Techniques
Calculating Averages Per Transaction Using DAX in Power BI
What's The Most Common Behaviour From Customers - DAX in Power BI
Detect Abnormal Patterns In Behaviour Using DAX In Power BI
What's Causing The Change - Power BI & DAX Techniques
Predict When Customers Will Purchase Next - Advanced Power BI & DAX
How To Create A Detailed Date Table in Power BI Fast
Outlier Detection & Visualization in Power BI - Advanced DAX
Calculating Average Monthly Purchases in Power BI using DAX
Review Of The New Power BI Feature - Quick Measures
How To Use Variables in DAX Formula with Power BI
Scale Your Power BI Reporting with Row Level Security
How to Create Virtual Groups & New Dimensions Fast in Power BI
3 Best Practice Tips For Organizing Your Power BI Models
Query Parameter Example in Power BI - Query Editor Tutorial
Evaluating Cross Selling Opportunities With DAX In Power BI - Advanced
Identify Which Customers Are Purchasing Behind Trend in Power BI w/DAX
Testing The Pareto Principle (80/20 Rule) in Power BI wDAX
Calculating New & Existing Customer Sales Using DAX in Power BI - Advanced DAX
Discover Which Custom Groups Contribute The Most To Profit in Power BI w/DAX
Advanced DAX - Show Percentage Sales Per Custom Group Each Year In Power BI
How To Calculate Averages per Day in Power BI with DAX
Analyze Margin Changes Over Time - Analytics w/Power BI & DAX
Filtering By Fiscal Or Financial Year Months & Quarters In Power BI
How Much Profit Are We Missing Out On - Power BI Insights
Which Customer Groups Experienced The Greatest Growth - Power BI & DAX
Did Margins Expand As Revenue Grew - Power BI & DAX Critical Analysis
Estimating Future Product Demand In Power BI Using DAX
How Many Unique Products A Customer Bought - Power BI Using DAX
Discover Top Salespeople Contribution To All Sales in Power BI w/DAX
Learn Where Your Profit Comes From Fast in Power BI w/Simple DAX
Was Revenue Growth Profitable - Analysis In Power BI w/DAX
Analyse Procurement Purchasing Decisions in Power BI using DAX
Find Your Top 3 Salespeople Per Region Automatically in Power BI using DAX
Find Lists Of Your Top Clients Across Different Measures w/DAX in Power BI
Find How Many Customers You Sell To Through Time in Power BI wDAX
Prevent YTD, QTD, MTD Results Projecting Forward - DAX Techniques in Power BI
Show MTD, QTD & YTD Calculations To Current Date in Power BI wDAX
Explore Which Customers Margins Have Contracted in Power BI w/DAX
Discover Your Top Products Per Region in Power BI w/DAX
Inventory Management Solution using Power BI
Compare Stock On Hold To Recent Sales - Inventory Management in Power BI
Discover The Best Selling Day For Your Products w/DAX in Power BI
Dealing with Multiple Currencies in Power BI using DAX - Updated Version
Handling Multiple Currencies in Power BI wDAX
Find Your Top Customers Through Time Using RANKX in Power BI wDAX
Answer If Margins Are Expanding or Contracting Through Time With Power BI
How To Track Sales Trends Through Time in Power BI using DAX
Solving in Power BI Which Products Have Contributed Most to Profit Growth using
How To Sort Date Dimensions By Custom Financial Years in Power BI
Calculating % Profit Margins in Power BI wDAX
Showcasing Trends Using Moving Average Techniques In Power BI
Quarter On Quarter Sales Trends In Power BI - DAX Formula
How To Create Custom Financial Year Quarters - Power BI
Calculate Transactions In Last N Days in Power BI Using DAX
Compare Time Periods With Non Standard Date Tables - DAX & Power BI
Year To Date Sales For Non Standard Calendar Tables - DAX in Power BI
Calculate Previous Weeks Sales - Advanced DAX in Power BI
Calculating Month On Month Change - Custom (445) Calendars, Power BI & DAX
Handling Weekday vs Weekend Dates in Power BI using DAX
Calculating Running Totals in Power BI Using DAX
Calculate Amounts Sold Between Two Dates In Power BI wDAX
Calculating Averages per Weekdays wDAX in Power BI
Comparing Actual vs Budget vs Last Year Results in Power BI wDAX
Dynamically Compare Monthly Information Cumulatively in Power BI wDAX
Handling Multiple Dates in Power BI with DAX
Calculate Difference This Year vs Last Year in Power BI with DAX
Calculating Sales Financial Year to Date in Power BI with DAX
'What If' Parameter Feature Review - Power BI & DAX
Reviewing The Huge Potential Of The Q&A Feature In Power BI
Best Practice Tips For Using The Advanced Editor - Power BI
What Is Measure Branching - Power BI Development Strategy
The DATEADD Function - The Best and Most Versatile Time Intelligence Function in
Advanced Product Budgeting Analysis - Power BI & DAX Techniques
Showcasing Budgets Cumulatively In Power BI - Advanced DAX Formula
Create and Set Budgets Automatically In Power BI Using DAX
Create Automatic Forecasts From Historic Data in Power BI using DAX
Dealing With Seasonal Budget Allocations in Power BI - Advanced DAX
Evaluating How You Can Make Budget - Power BI & DAX Scenarios
Budgeting Examples in Power BI using DAX
Advanced Forecasting Logic in Power BI with DAX
Advanced Forward Forecasting Techniques in Power BI with DAX
RANKX Considerations - Power BI & DAX Formula Concepts
Using The AVERAGEX Function - DAX Tutorial & Examples
Using LASTNONBLANK in Power BI - DAX Function Deep Dive
Using The CROSSJOIN Function In Power BI - DAX Concepts
Using ALLSELECTED - DAX Formula Concepts In Power BI
Showcasing Top or Bottom Results Using Ranking Techniques - Power BI
When & How to Use TOPN in Power BI - DAX Function Tutorial
Comparing Performance Using The ALL Function - Power BI & DAX
How to Use The ALL function in Power BI & DAX
Harvest Power BI Slicer Selections To Use With Other Measures - Advanced DAX
Why Measure Groups In Power BI Are So Important
How To Use Natural Language Query (Q&A) In Power BI - Detailed Review
Analytics Function For Power BI Scatter Charts Review
Goals for this training
Goals for this training
Why reporting in Power BI is better than in excel
Power BI explained
The essential way to source data for Power BI
Why you are now building analytical solutions
Resources we will be using in this course
4 Pillars of high quality Power BI solutions
Making sure data types are correct
Create groups for your queries
What is the query editor?
Fundamentals of using the query data
Querying multiple data sources in the same model
Best practices for transforming data in the query editor
Row & Column transformations
What is 'M' and why do you need to have an understanding
Query dependencies
Importance of date tables
Introduction to the importance of the data model
Where to manage relationships for your data model
Understanding what types of tables you have & setup techniques
Setting up relationships in your models
Difference between active and inactive relationships
Building out additional dimensions in your data
DAX explained & key techniques to learning it
Getting started & naming conventions tips
Calculated columns versus measures
Creating a measure table & organising your measures
Context! - What is this?
Evaluation (initial) context
Aggregating formulas or filter context
Iterating formula or row context
Building measures on measures (measure branching)
CALCULATE function - the most important function in DAX
Developing visualizations in Power BI
How to publish your data to the web
Power BI service explained
Main table functions
Simple Time Intelligence functions
More advanced DAX formula examples
What you can achieve if you learn DAX well
How to create colour themes for your reports
Design best practice tips
Visualization and report formatting
Managing interactions between visuals
Additional filtering across your reports
Analytics automation features
Importing custom visuals
Apps & Workspaces explained
Reports vs Dashboards
Q+A feature in-depth
Admin settings within the online service
Enterprise architecture recommendations for Power BI
Develop Power BI desktop templates to scale reporting requirements
The Microsoft Power Platform
Why Power BI is going to be huge!
Email subscriptions, comments and other compelling features
Row level security
DAX Total Issue Within Predicting Results Showcase - How I Fixed It
Detecting & Showcasing Outliers in Power BI - Full Workshop Replay
Understanding the CALCULATE function - DAX in Power BI
Customer Trend Analysis in Power BI Using DAX
My biggest tip for members currently sits in this tutorial
Compare One Sale Versus The Last Sale (No Time Intelligence) - Advanced DAX Insights
Where Are Your Best Sales By Product? Advanced Analytics with Power BI
SWITCH True Logic Explained
Update to Multiple Currencies Management in Power BI – Advanced DAX
Syntax, Comments & Variables For DAX Formulas - Power BI
Create Automated Lists Based On Ranking Calculations in Power BI
What Is Measure Branching? - Power BI Development Strategy
New vs Existing Customers – Advanced Analytics w/DAX
Managing Seasonality in Budgeting Analysis – Advanced Power BI
Latest end to end demo up on Enterprise DNA TV
What you will learn during the next Enterprise DNA Learning Summit
Discovering Advanced Insights w/Power BI - Enterprise DNA Webinar Series

HOW TO GET STARTED WITH THE SUPPORT FORUM

The Enterprise DNA Support Forum has been created to provide additional assistance and support to members.

Please note that the forum has not been developed to enable consulting, on-demand coaching or development services for free. Support given is primarily to assist members in educating themselves to answer their own queries.

How to start a forum topic or thread

From the forum home page you can start a thread by selecting the icon at the bottom right of the screen.

What are categories?

A category is basically the topic your query comes under. For example a general Power BI question would need to be grouped in the Power BI category. The same for a specific DAX or Query Editor question.

It’s important to assist us in grouping these topics into the right categories for ease of searching later on.

HOW TO SEARCH FOR CONTENT WITHIN THE FORUM

You can easily search for content within the forum.

Before answering a question it’s recommended to complete a quick search to discover if your query has been asked before by another member.

You can complete searches using the icon below

Can I be more specific in my searches?

Yes you definitely can. See below for how to do this.

Can I do a quick search for all the posts I have worked in or on?

Yes this can easily be done also. Just enter your user name into the Advanced Search section and hit submit

TIPS FOR ASKING QUESTIONS IN THE FORUM

There are many ways you can assist those providing support when asking questions on the support forum.

Please review the below in detail before asking any questions on the forum.

Asking better questions will help those answering your query and also help you in getting a strong solution faster.

Please break out separate questions into separate topics

When thinking of a topic title name, think about what you would likely type into google search to get the answer.

Please make sure the topic is tagged in the correct category. For example a DAX formula question is tagged in the ‘DAX Calculations’ category

Please provide as much context to a question as possible. This includes the data, the model, the formula, the filter context etc. To get good answers just post as much detail about the issue or question as possible.

Please be patient, this isn’t an on-demand forum. Response times will likely be anywhere between 12-48 hours.

If you find a solution to your questions before it is answered please place this information into the forum thread and mark the questions as solved.

Please remember the forum is not a free development service or on-demand coaching service. It’s to assist your learning around how to complete Power BI development yourself. We will do as much as reasonable to help, but if there is some learning to be done, you may be directed to relevant tutorials to learn this yourself rather than having answers continuously delivered to you.

TIPS FOR ANSWERING QUESTIONS IN THE FORUM

Anyone can answer questions on the forum, and we encourage it greatly, as there is no better way to learn than by helping others.

Please look to give as much support as possible without venturing into offering free consulting services - this is not the intention of the forum. We are looking to offer valuable support to members so that everyone can learn how to complete work themselves effectively.

Some further important tips below.

Provide as much educational support as you can on top of answering the question. The best thing to do is to link to the significant amount of Enterprise DNA content that is available.

Even though in support, answers are best solved if you are really responsive during the first 48 hours since the post was made, you don’t want to just reply for the sake of replying quickly; only reply if you have something that can move the question resolution forward.

Focus on things that you know to start with. Do not be worried that you cannot do or answer everything.

Pace yourself. You don’t have to answer everything. Set yourself a small target of just answering two or three questions when you are online (or more, it’s up to you).

Be nice. Add a personal touch. This is a great community and is growing bigger by the day. It’s a great way to build your own profile through time.

HOW TO COMPLETE A FORUM THREAD

If your question has been answered within the forum it is important to mark your thread as ‘solved’.

You can do this very easily below.

First click the ellipsis at the bottom of a post that has answered your question the best.

Then tick the below box.

You will then see this.

It’s important to do this so that those answering questions know what to focus on.

You will see on the home page that solved topics are easy to spot.

Thanks for your assistance with this.

1 Like