Latest Enterprise DNA Initiatives

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.



1 Like
Advanced Table Functions: GROUPBY
DAX Calculations - Advanced DAX
Using ALLEXCEPT To Stop Cumulative Total From Resetting - DAX Solution
Want grand total of average function to be a sum not an average
How To Use The GROUPBY Function In Power BI - DAX Function Review
Customer Engagement Analysis
Customer Cohort Analysis
Adding a slicer based on Measure
Cumulative Sales with no floor date
Time to Complete Budget Allocation
Revenue Pace and Running Total - Dax calculation
Using Data Model Metadata in Tooltips
Combine payment detail, reflect monthly until total is reached
Comparison column in a matrix
Need to grab a previous value
Count Condition with DAX
Complex discount calculation ( time period,customer,products)
Weighted Average and Dynamic Indexing
Web Connection with Credentials
DAX Calculation - Filtering for latest record <= last sliced date
Last Transaction Date and Price
Card to display name chosen
Difference between times from different tables
Forecast Model convert annual data to week and month
Calculating Weighted Average not involving dates
Average of Summed Values
Create a link between two databases and calculate forecast per week
How to automatically refresh PBI desktop file!
Labor Hours summed by date of square footage
The Role Of Geospatial Data In Logistics With Paul Lucassen
How Data Literacy Is Changing The Way People Work With Jamie Beason
How Data Analytics Make Companies More Resilient By Shiv Misra
Unique Data Insights in the Healthcare Space with Anuj Kapoor
DirectQuery question
Huge updates released this week in the Analyst Hub...learn more here
Sales % (yearly) - - better way to calculate?
Calculating Time metrics of the students
Remove Rows from Table but Count the Total Measure
Stock on Hand Total
What New Content Do You Want to See in 2021?
Formatted measure not displaying correctly
How to Lookup a value from a field in same table, based on it having an early start date
Dynamic Grouping returning error
Working with API's
We've improved the formatting of all text in the Analyst Hub
Want to highlight the amazing collaborative aspects of the Analyst Hub
I want to work on some Analyst Hub templates...what should we prioritize?
About the Geospatial Analysis category
Amplitude Analytics to Power Bi - Write DAX Formula to count number of Users with certain events
Calculating cumulative sales last quarter
Filtering a table of values by 3 separate column values
Stock Aging and FIFO Valuation
Data Sparsing based on Specific Keywords
Aging report visualization
Join Two rows together and return a conditional Keep
Problems with Merging two tables by UK Post Code
About the Analyst Hub Updates category
Creating a Data Culture Using Power BI with Brian Julius
About the Problem Of The Week category
Imagine the Possibilities of Data Products with Power BI
The Rise of Self-Service Business Intelligence with Alex Moy
Tornado Chart / Clustered Bar Data Labels
Aging segmentation help
Top 5 and Bottom 5 Product within each categories
Top 5 and Bottom 5 Product within categories
Ranking with Calculated Measure and Grouping
Mixed area/line chart
How to filter data by Account Name via an ID number
Distribution of hours worked by employees en DAX
Restricting the date in date slider
How to get a CUSUM instead of the total in a Matrix
Using a lookup table to filter a fact table
PNL Report - issue when using not original value for one of the headers
Paginated Reports
Analyse in Excel - Pivottabel Drillthrough
Cumulative Discounted Sales
Business Analytics Week Dataset 14-16/12
Date Calendar Not picking measures for certain Year
Should I keep my table wide or long?
Dax Logic help needed
Iterate over each column and add new
Rest API Google Analytics connection failed in Dataflows
Calculating Average Warehouse Code sales
Graph not showing the right value
Subtotal is now ok, but Grandtotal is still wrong, but not in waterfall chart
Elapsed Working Hours (different per country) excluding weekends
Create a baseline sales
Days Between 1st or Nth Orders for different customers
Iwatch does not display the kpi visualization
Database Structure
Need Guidance : Survey Data Story Telling & Visualization
SUM a Text Field
RANKX avoid duplicate
Conditional Filters - Measure
Knowledge Base - Link Overview
Power BI Portfolio - App Overview
Prioritization Matrix - App Overview
DAX Clean Up - App Overview
Edna Bot - App Overview
Colour Theme Generator - App Overview
Business Central Dataflow
Cumulative sum with date hierarchical
Filter dim table differently in two columns
Filter dim table differently in two columns
Cumulative sum with date hierarchical
Overview Of The Analyst Hub
Analytics Planner - App Overview
Matrix & Concatenations with universal connections
Binning customer by year revenues using a Live Connection to tabular model
About the The Analytic Mind category
Month over Month calculating incorrect
Forecasting of production data
Help with Merger queries or Relationship between two fact tables
HELP - Getting a many to many relationship when it should be one to many
Become A Corporate Sponsor Of Enterprise DNA's Power BI Challenges!
Comprehensive New Power BI Showcase Resources To Inspire Your Own Development
5-questions on using Power BI with Dynamics 365 and/or PowerApps
MySQL connection error (unblock with mysqladmin flush-hosts
MICROS & SAGE integration
How to speed up Power BI reports for opening and refreshing?
Boost Your Power BI Productivity 3x - Format, Save And Reference All Your DAX
Using variables (or something similar) in multiple expressions
SWITCH Optimization
Advanced donor loyalty
Calculate Age of Harvest with differing inputs
Dynamic Image in Power BI Report
Recursive totals for projects for different Sites
Blank in the Slicer when filter in Power Query Editor
RLS Question on how to apply security on filter & transaction
Number of Order on each segment
Dynamic Grouping of Aggregated Data
Help with dax in a matrix
Getting Updated Last Refresh Date/Time In Power BI
Dynamic currency conversion + context + YTD
Data accuracy statistic
Optimized alternative to Maxx (Summarize)
Share Your Ideas With Us And Drive The Direction Of The Analyst Hub
Analyst Hub Is Live! - Jump In Now And Try It Out
Dynamic Date Range Slicer Using A Period Table For Your Power BI Report
Grouping Bookmarks by Report Page in Power BI
Developing A Superior Navigation Experience For Your Power BI Reports
How To Add Or Overlay Tooltips To Any Area Within A Power BI Report
Expand Your Creative Mind To What's Possible With Power BI Reports
The Best Power BI Custom Visual You've Never Heard Of
Insurance Complaints Reporting Application
Procurement Insights Report Development
Creating A Dynamic Stock Quote App Fast In Power BI
Creating Measure Tables & Organizing Measure in Subfolders In Power BI
Showing Last Refresh Date/Time In Power BI Reports
Having a Context Issue for my DAX Code
DAX Grand total with Filters
Executive Insights
Product Insights
Sales Scenario Analysis
Advanced Budgeting Insights
Detecting Outliers
Regional Summary
Financial Reporting
Cohort Analysis Showcase
Product Sales Overview
Regional Profit Insights
Export Data from Power Query (Private data set)
Assembly Line Capacity Actual Vs Planned
Matrix Balance Sheet by month, Quarter or year
Create a Moving Range Measure
Sorting Date Table Columns In Power BI
How To Work Through Extensive DAX Formulas In Power BI - Formatting Tips
Showcase Top Five Customers This Period vs Last Period - DAX Insights Using TOPN
Unpivot Multiple Column Pairs In Power Query
How To Remove Duplicate Rows In Power Query Based On Conditions
How To Compare Time Related Insights Together With Difference Date Slicers
Setting Up Backgrounds For Power BI Reports Using PowerPoint
Highlight Growth Trajectory Of A Customer Through Time - Analysis Tip For
Quickly Discover When The Last Date Something Occurred Was Using DAX - MAXX
Retrieve The Previous Value Taking Into Account All Weekends And Holidays -
In-Depth Learning Around The Cumulative Total Pattern In DAX - Power BI Tips
Easy Hex Code Wrangling For Power BI
How To Select Colour Theme For Your Power BI Reports
Placing Dynamic Maps In Tooltips In Power BI - Ultimate Data Viz Technique
Creating A Visual Tooltip In Power BI - Make Your Consumers Really Go Wow
This Is What A Reporting Application Can Look Like - Power BI Visualization
Creating A Dynamic Tooltip With Embedded Charts Using Power BI - Epic Data
How To Create Text Summaries With Dynamic Measures Embedded Into The Description
Effectively Show Change In One State To Another State Using Unique
Creating Information Boxes To Highlight Interesting And Dynamic Insights In
Dynamically Showcase When Customers Purchase Across All Dates - Power BI Viz Tip
3 Ways To Discover Inspiration For Your Report Designs In Power BI Through
Dynamically Showcase Ranked Groups Visually Over Time In Power BI
Showcase Unique Insights Using Conditional Formatting Within Charts - Power
How To Change The Sort Of Visualizations Dynamically In Power BI
3 Visualization Tips You Can (And Should) Use In Your Power BI Reports
Dynamically Showcase Segment Insights Across Your Entire Power BI Report
Page Turning Visualization Idea For Power BI - Impressive Dashboard Technique
Showcase Which Multi Selections Are Selected Within A Slicer - Useful Visual
Why Using Good Colours Across Your Reports Is Essential In Power BI
Building A Reporting System With Power BI - Taking Development To The Next Level
Advertising & Marketing Campaign Insights Using Power BI - Reporting
Format Your DAX Formulas Using Our DAX Clean Up App - New Updates To Logic
Creating The Ultimate Date Table In Power BI - How To Do This Fast (Updated Code)
Native Query against on premise SQL
Cascasde Waterfalls
Composite model
Chart of Accounts with Sub Accounts and changing descriptions
Last year comparative same day (monday vs monday, 01 vs 01))
Receipts Conciliation
Near Duplicates - Power Query
Dynamic Date Range Slicer conflicting with outside period references
Mixed date formats on visualisations
Disabling Refresh for old files in the onedrive folder
Currency conversion measure is selecting month prior to current context
Logic re switcher
Duration between two dates excluding Holidays and Weekends
DAX FORMULA Oil & Gas Industry Analytics
Hierarchies or path function
How to create dynamic tooltips display for a bar chart
Totals in my aggregations not showing
Asset Allocation Roadmap for Investment Portfolio
SQL Statement and Data Refresh Using Personal Gateway
Check Out The Latest Webinar Detailing The Analyst Hub
Match multiple columns and rows across multiple tables
Distinct count ID by the last date change into the last school they got enrolled
Current Vs. Target Allocation Weighting
Web.Content parameters from Postman dump
Leverage from a new measure a KPI (Status) created on Tabular Editor?
Automatic refresh of Dynamics 365 data
Product Gains & Losses Over Time
MinX in a table
How to generate surrogate keys for SCD fast in Power BI
Identifying unused tables,measure and columns
Dynamic selection of PDF file preview
Convert The Date Table Function Into A Table Query in Power BI
Create a Perpetually Updated Practice Dataset in Power BI
Calculated table with a date slicer
Running total with Beginning Balance
Matrix calculus - specific formula for matrix
Limiting or stopping further FILTER
Dynamic selection of PDF file preview
Power Query Editor Help or Use DAX Calc Column?
Power BI Challenge - Budget wage
Time to perform activity measure
Power BI Model - Help with DAX Calculation or Data Model structure
Report Snapshot/Freeze Data Scenario
Waterfall chart - group results by top/bottom/other
Data Model for Consolidated Households vs. Non Consolidated Individual Accounts?
Delivery App Review - Power BI Speed Build
DAX to calculate value where data has multiple data rows
Multi Dimension Sorting in a clustered column chart
Power BI Challenge #3 - Wrap Up & Winning Submission
Brand new videos detailing the Enterprise DNA Education Platform now available
We're trying to build up our Ecosystems - can you help?
Displaying Expansion Buttons when Embedding in a Portal
Drillthrough Question
Five Strategies To Enhance Your DAX In Power BI
User Credential Passthrough to Oracle DB in Direct Query
FYTD Hours calculation
Opening and closing inventories
Cumulative Cohort analysis
Counts number of Incidents with a Date slicer
Backlog- count a ticket in each month it is not solved
Adding Parameter in Data Table M Function - Query Editor Tutorial
Turning Multiple Calendar Type Layouts Into Tabular Format In Power BI -
Create A Delimited List of Values in Power Query - Query Editor Tutorial
Accounting For Missing Data In Currency Table w/PowerQuery
Accounting For Missing Currency Rates w/DAX
Create A Simple Lookup Table From Subtotal Rows - Power BI Optimization
Changing Date Formats w/Power Query Editor - Simple Technique For Power BI
HR Consultation Insights - Power BI Speed Build
Get a value to apply as a filter
Power BI Random Drawing Report
Extract Records From Delimited Data In Power BI
Setting Up A Dynamic Startdate And Enddate For Power Query Date Tables
Creating Records For Daily Values With Power Query
Developing Custom Tiebreakers For RANKX
Managing Your Supply Chain Data w/Power BI - Analysis Techniques
Turn Calendar Type Layout Into Tabular Format In Power BI - Query Editor
Display only two rows month wise in Table Visual with DAX
Fiscal Period Offset in Power Query
Backlog- count a ticket in each month it is not solved
Totals Not Coming Correct Virtual Table
Dynamic reporting with Fiscal Year (Portfolio of Companies)
Non-obvious relationship
Getting the data from onedrive and google drve
Forecast to Actuals formula
Governance - General access information of users for applications
Financial Reporting Template Formatting
Customer Deep Dive - Power BI Speed Build
How To Format Currencies in Power BI w/DAX
Simple Currency Conversion in Power BI w/DAX
Calculating Workdays Between Two Dates in Power BI
Using The Extended Date Table - OFFSETS in Power BI
How To Create A Holiday Table In Power BI - Time Intelligence in Power BIe
How To Convert YYWWD Code Into Date Value In Power BI - Query Editor Tutorial
Cyclic reference in Power Query
Error Updating Report on Power BI Service
Retrieving all rows using a stored procedure with parameters
Replace Null value to today's date in power query
Percentage change speed
Calculating Customer Life Time Value (CLTV) From Cohort Analysis Show Case
Data Grouping/Merging and picking the latest date
Conditional formatting for KPI variances
Time Intelligence series by BrianJ and Melissa
Consumer Goods Sales Insights - Power BI Speed Build
Using The Extended Date Table - ISAFTERTODAY
Date Harvest Deep Dive - Power BI Time Intelligence
Optimizing Supply Chain Metrics Through Time w/Power BI & DAX
How To Mask Sensitive Data In Power BI
Changing Folder Location w/ Query Parameter- Query Editor Tutorial
How To Use M Function In Creating Extended Date Table In Power BI - Query
PowerQuery to extract time series data for lookup tables
HELP: % with dynamic Denominator
OR Slicers in Direct Query
New Customer Analysis w/Power BI
Stock Market Dashboard - Scenario Method
Financial Reporting in Power BI
Financial Reporting Templates
Advertising & Marketing Campaign Analysis
Time-Based Cohort Analysis
Project Management Insights w/Power BI
Inventory Management w/Power BI
Scenario Events Expanded w/Power BI
Time Intelligence Intensive
Supply Chain Analytics
Call Center Insights w/Power BI
Oil & Gas Industry Analytics
CRM Data Insights
Banking Analytics w/Power BI
Cross Selling Application w/Power BI
Google analytics report sample
How to calculate count & Sum only the last year's lost contracts
Relationship in the model and output in table and formula
Relationship in the model and output in table and formula
Need a help at Gross Margin % as a row values
Application of Slicers on the Visuals
Using the outcome of a measure as a constant
Thoughts about "New Customer Analysis"
Control P Chart in PowerBI
RLS for an Org hierarchy
Financial Reporting Previous Year Actuals
Session updates for our upcoming Business Intelligence Summit - now available!
Calculate first 12 months qty sold since open date of a store
Embedded Power BI
Days in Date Context for FY_Month Budgets
Utilization % by default area vs other areas
Call Center Insights w/Power BI - latest member only event happening this week
Custom Fiscal Calendar and Previous YTD
Basket Analysis with Support, Confidence and Lift
Assistance with Current Staff Calculations
Help on Dax logic affecting only for one context value not impacting others
Fun project: Latest Topics on the Enterprise DNA Forum
How to make the different matrices dynamic?
Mailchimp Intregration and Automation
Error Messages - When Refreshing
Error Messages - When Refreshing
Time Intelligence Help - Previous MTD till Current Date
Make different matrices dynamic
Calculating First Year Sales - with pics this time!
Line Chart with fixed axis scales and increments?
Sum of cumulative measure
Colour & Themes
Visualisation options
Measure branching
Simple measures
DAX Calculations - Measure groups
DAX Calculations - What is DAX?
Relationships between tables
What is data modeling?
Advanced transformations
Organising your queries
Creating a date table
Simple transformations
Query editor explained
Data scenario explained
Resources Explained
Introduction To Ultimate Beginners Guide To Power BI
Cumulative totals to a specific date
Financial Report Templates
How To Compare Two Lists Of Calculated Data Virtually - Advanced DAX Technique
Dealing With Mulitple IF Statements In Power BI Using DAX
How To Break Out Large Tables Into Multiple Tables And Build A Model - Power BI Tips
Simple Visualization Tips & Techniques For Your Reports In Power BI
Showcase Insights Using The Multi Threaded Dynamic Visuals Technique In Power BI
Combining Table Functions To Optimize Formulas In Power BI - DAX Technique
Speed Issues in Financial matrix - Follow on from solved issue on variables
Count unique customers in a status position given Start Date and End Date
Calculate stock in hand compared with last year sales
Banded column shading - Using Conditional Formatting?
Complex Overlay Filters
Showing revenue at benchmark stores per date
Budget, Actuals and Forecast
Problem with changing the type of date needed for incremental refresh
Cohort % of total by periods
Calculating Monthly Revenue per group per product per schedule
Speed Issues in Financial matrix - Follow on from solved issue on variables
Calculate team head performance
Displaying Sequential Months with multiples years
Amazon Merchant Web Services (MWS) Seller Central
Video: Top 3 Salespeople per Region
Current Year based on Boolean Value
Combine Worksheets in a Workbook
Week Level Data
Creating Business Themed Dashboards Using The Power BI Online Service
How To Organize The Power BI Online Service For Maximum Impact
Create A Pareto Chart In Power BI Using DAX Function Combinations
How To Segment Your Data Based On Any Measure In Power BI Using DAX
Who Is Our Top Purchasing Customer Per Product? - Power BI Analysis
A Review Of Common Time Patterns To Use In Power BI - DAX Formula Review
Calculating Dynamic Profits Margins - Easy Power BI Analysis w/DAX
SUM vs SUMX - What's The Real Difference Between These DAX Measures
Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand
Dynamic Segmentation With Dynamic Parameters - Advanced Power BI & DAX
Cash Flow reporting--Help! Help!
EARLIER function
Advanced Table Functions: GENERATE
Intersect & except
Advanced Table Functions: CALCULATETABLE
Advanced Table Functions: UNION
Advanced Table Functions: ROW
Advanced Table Functions: CROSSJOIN
You can also combine table functions together
Advanced Table Functions: SUMMARIZE
Advanced Table functions: ADDCOLUMNS
How to manipulate virtual tables using table functions
Data types and operators
The importance of naming conventions
Introduction to DAX: Formula syntax
Introduction to DAX: Measure groups
Formatting DAX code
Using variables to simplify formulas
Writing comments in your code
Quick measure feature (positives vs negatives)
DAX doesn't work unless your data model and relationships are setup correctly
The only way to learn is to practice
Calculated columns vs measures
Understanding context & how the DAX calculation engine works
Evaluation or initial context
Aggregations or filter context
Iterations or row context
Understand context in calculated columns (context transition)
How the data models interates w/DAX (filter propagation)
Getting started with DAX: DAX function types
Aggregation Functions - SUM/AVERAGE/MIN/MAX
Iteration Functions - SUMX/AVERAGEX/MINX/MAXX
Measure branching methodology
How to use combinations of DAX functions
Logical Functions - IF / SWITCH
DIVIDE function
Other Function Types - Information, Text, Conversion, Date & Time, Boolean
What are table functions? (think of virtual tables!)
Simple Table Functions: FILTER
The versatile VALUES function
ALL function - the remove filters function
All & allexcept
ALLSELECTED requires a deeper understanding
How filter and row context work with relationships
Working with one table versus many tables
RELATED function
Why CALCULATE is important?
Why do you even have to use CALCULATE? (It's all about CONTEXT!)
What can you do when you use CALCULATE?
How are formula calculated when you involve CALCULATE?
How To Use Options Within Bookmarks in Power BI
Using Bookmarks To Change Views On The Report Page In Power BI
Visual showing Months before and after dates within my fact table
Calculate Filter problem
Cost Variance vs Average for a FY
Measure on X axis of visual (Using Switch to segment a continuous variable)
All Function Vs Values Function Usage in Topn
Data Model Design
Meet The Enterprise DNA Power Users
The Analyst Hub is coming very soon!
Counting Dynamic Text Results Measure
Power BI Challenge 7 - Purchases, Inventory And Sales Entry from Sam M
Brand New Demo Of The Analyst Hub
Sales Pipeline Stages
% of total issue using custom slicer
Daily Forecast Allocation Weighted by Day Of Week
Brand New Power BI Challenge Showcase Now Live At Enterprise DNA Online
How To Install Practice Dataset Power BI Tool
Introducing myself and posting questions to the forum
New 'Projects' Feature Now Being Developed Inside The Analyst Hub
How The Analyst Hub Will Become The Social Network For Power BI Users
New Virtual Power BI Deployment Event Series For Data Leaders
Circular Dependency error while trying to calculate funding based on Closing Balance+Movement
Power BI Challenge #7 Now Complete - Amazing Round Of Submissions
Global Statistics
Insurance Applications
Employee Insights
Food Distribution Business
Customer Insight
Inventory Management
Website Analytics
Retail Sites Showcase
Multi Year Performance Analysis
FX Risk Management
Time Intelligence Functions - Power BI Showcase
Manufacturing Operations
Transportation Bookings Management
CRM Sales Data - Power BI Showcase
Project Management Dashboard
Financial Reporting In Power BI - Power BI Showcase
Quarterly Business Insights
Accounts Receivable Insights
Stock Market Dashboard - Power BI Showcase
Advertising and Marketing Campaigns
Inventory Analysis
Sales Performance
Insurance Portfolio Analysis
Call Center Insights
Customer Engagement Analysis - Power BI Showcase
HR Consultation Insights
Financial Analytics
Customer Insights
Delivery App Review
HR Interview Insight
Optical Data - Power BI Showcase
Client Satisfaction
Delivery Application
Insurance Complaints
Banking Clients
Product Discounting Scenarios
Management Dashboard
Customer Goods Sales
Understanding Your Customers Better
EU Country Overviews
US Regional Performance
Simple and advanced filters with CALCULATE using FILTER function
What are time intelligence functions?
Why you must have a date table?
The best time comparison function - DATEADD
Aggregations - YTD, QTD, MTD
Practical examples using time intelligence functions
Understanding how variables are evaluated
Using table variables to simplify ultimate formulas
Using variables to clean up multiple measures
When to create virtual vs physical relationships?
Creating virtual relationships: TREATAS
How does USERELATIONSHIP compare?
What is DAX & how to learn to master it?
Course resource pack download
Fixing errors with your totals efficiently
Budgeting allocation algorithm
Using virtual tables with COUNTROWS
Compare multiple quarterly sales on each other
This is where the measure branching methodology really shines
Practical examples for using ranking functions
Ranking functions: TOPN
Ranking functions: RANKX
Unique Dax grand total incorrect
Discovering Advanced Insights w/Power BI - Enterprise DNA Webinar Series
What you will learn during the next Enterprise DNA Learning Summit
Latest end to end demo up on Enterprise DNA TV
Managing Seasonality in Budgeting Analysis – Advanced Power BI
What Is Measure Branching? - Power BI Development Strategy
New vs Existing Customers – Advanced Analytics w/DAX
Create Automated Lists Based On Ranking Calculations in Power BI
Syntax, Comments & Variables For DAX Formulas - Power BI
Update to Multiple Currencies Management in Power BI – Advanced DAX
SWITCH True Logic Explained
Where Are Your Best Sales By Product? Advanced Analytics with Power BI
Compare One Sale Versus The Last Sale (No Time Intelligence) - Advanced DAX Insights
My biggest tip for members currently sits in this tutorial
Customer Trend Analysis in Power BI Using DAX
Understanding the CALCULATE function - DAX in Power BI
Detecting & Showcasing Outliers in Power BI - Full Workshop Replay
DAX Total Issue Within Predicting Results Showcase - How I Fixed It
Row level security
Email subscriptions, comments and other compelling features
Why Power BI is going to be huge!
The Microsoft Power Platform
Develop Power BI desktop templates to scale reporting requirements
Enterprise architecture recommendations for Power BI
Admin settings within the online service
Q+A feature in-depth
Reports vs Dashboards
Apps & Workspaces explained
Power BI service explained
How to publish your data to the web
Importing custom visuals
Analytics automation features
Additional filtering across your reports
Managing interactions between visuals
Visualization and report formatting
How to create colour themes for your reports
Developing visualizations in Power BI
Design best practice tips
What you can achieve if you learn DAX well
More advanced DAX formula examples
Simple Time Intelligence functions
CALCULATE function - the most important function in DAX
Building measures on measures (measure branching)
Main table functions
Iterating formula or row context
Aggregating formulas or filter context
Evaluation (initial) context
Context! - What is this?
Creating a measure table & organising your measures
Calculated columns versus measures
Getting started & naming conventions tips
DAX explained & key techniques to learning it
Building out additional dimensions in your data
Difference between active and inactive relationships
Setting up relationships in your models
Understanding what types of tables you have & setup techniques
Where to manage relationships for your data model
Introduction to the importance of the data model
Importance of date tables
Query dependencies
What is 'M' and why do you need to have an understanding
Create groups for your queries
Making sure data types are correct
Row & Column transformations
Best practices for transforming data in the query editor
Querying multiple data sources in the same model
Fundamentals of using the query data
The essential way to source data for Power BI
What is the query editor?
4 Pillars of high quality Power BI solutions
Resources we will be using in this course
Why you are now building analytical solutions
Power BI explained
Why reporting in Power BI is better than in excel
Goals for this training
Goals for this training
Multi-Layered Scenario Analysis using DAX in Power BI
Sensitivity Analysis In Power BI Using DAX
Complex 'What If' Analysis Example In Power BI Using DAX
Extending Layered Scenario Analysis Techniques - Advanced DAX & Power BI
Layering Multiple 'What If' Scenarios In Power BI - Advanced DAX Concepts
Run Scenarios On Changes To Your Average Order Size in Power BI w/DAX
'What If' Sensitivity Analysis in Power BI using DAX - Advanced Technique
Predict Profitability For Future Time Periods - DAX & Power BI
Getting Started With 'What If' Paramaters - Scenario Analysis Techniques
Find Patterns In Your Data With Internal Logic using Power BI & DAX
How To Discover Clusters In Your Datasets Using DAX in Power BI
Detailed Banding & Segmenting Example in Power BI using DAX
Create Dynamic Visuals Based on Ranking in Power BI wDAX
Threshold Triggers in Power BI using DAX - Advanced Technique
Secondary Table Logic Inside Of Power BI Using DAX
Grouping & Segmenting Your Data With DAX Measure Logic
Understanding Anomalies with DAX in Power BI - Analytical Technique
Combining Dynamic Grouping With Additional Ranking Logic with DAX
Dynamically Change Size Of Visual Based On Ranking Selection in Power BI using
Isolate Your Top Salespeople For Growth In Margins - Power BI & DAX
Segmenting Dimensions Based On Ranking w/DAX in Power BI
Dynamic Ranking Tables In Power BI - DAX Formula Review (RANKX)
Create Custom Dynamic Groups In Power BI - Advanced DAX
Create Cumulative Totals, No Date, No Index - Advanced DAX Techniques in Power
Fixing Complex Total Errors - DAX Formula Concepts
Cumulative Totals Across Averages & Dynamic Date Logic - Advanced DAX
Multi Threaded Dynamic Visuals in Power BI - Advanced Power BI and DAX
Develop Compelling Visualizations Using Filter Fields & Visual Interactions in
Creating Dynamic Commentary in Power BI
Multi Measure Dynamic Visuals - Data Viz Technique In Power BI
Considerations For Dark Backgrounds In Power BI Reports
Visual Examples For Showcasing Sales Performance In Power BI
Developing Compelling Power BI Reports & Dashboards - Power BI & DAX
Changing The Interactions of Your Visuals in Power BI
Data Bars in Table Visualizations - Significant Viz Update in Power BI
Designing Reports For Mobile Devices..Use This Feature in Power BI
Analytics Function For Power BI Scatter Charts Review
How To Get Custom Icons Into Your Power BI Reports
Create Background Design Plates For Your Power BI Reports
Shape Map Visualization - Power BI Visual Techniques
Create An Entirely Dynamic Report In Power BI - Advanced Visualization Technique
How To Use The TREATAS Function - Power BI & DAX
When To Use The CALCULATABLE Function - DAX Function Techniques
How To Use The INTERSECT Function - Power BI & DAX Tutorial
Compare Current Sales To Previous Best Month - Advanced Time Intelligence In
Find Weekday & Weekend Day Numbers Within Months - Advanced DAX
Project A Current Trend Forward Repeatedly - Forecasting Techniques, Power BI
Dynamic Results vs Budgets & Last Year - Power BI Financial Reporting Techniques
Break Out Outliers & Analyze Over Time - Advanced DAX Concepts
How Many Customers Have Multiple Product Purchases - Power BI & DAX Analytics
What Is The First Product A Customer Purchased? - Power BI Analytics
Creating PnL Statements In Power BI - Financial Reporting Example
Data Setup Tips For Financial Reporting - Power BI
How Many New Customers Do You Have Each Month - Advanced Power BI Analytics
Evaluating New Customer Sales - Advanced Analytics in Power BI
Dynamically Drill Into Your Top 20% Of Customers - Power BI & DAX Technique
Using SWITCH True Logic In Power BI - DAX Concepts
Normalizing Results On Different Days - Time Related Analysis In Power BI Using
Normalizing Results On Different Days - Time Related Analysis In Power BI
Dealing With Products That Have Changing Prices - Power BI Analytical
Show Days Before Or After A Selected Date -Advanced Power BI Visual Techniques
Show Last N Sales Of A Customer Only - Advanced DAX Technique Using TOPN
Placing Workday and Weekend Day Numbers Into The Date Table - Power BI Time
Calculate The MEDIAN Value In Power BI - Statistical Analysis w/DAX
Calculate The Total Of Average Results In Power BI Using DAX
Showcase The Top Result Name Within A Card Visualization - Power BI Technique
How To Calculate A Cumulative Run Rate In Power BI Using DAX
Calculate A Reverse Cumulative Total In Power BI Using DAX
Creating Virtual Relationships Using TREATAS - Advanced Power BI Technique
How To Create Tables Combining UNION & ROW Function - Power BI & DAX
Aged Trial Balance Grouping Examples In Power BI - Business Analytics With DAX
Different Ways You Can Use The TOPN Function - DAX In Power BI
When And How To Use The EARLIER Function In Power BI - DAX Concepts
Best Practice Tips For Organizing Your Power BI Models
Integrated Financial Reporting - Power BI Techniques For Accounting & Finance
Budgeting Performance Segmentation - Analytical Technique For Power BI Using DAX
Cumulative Totals Deep Dive - Power BI & DAX Formula Review
Allocating Detailed Monthly Budgets Or Forecasts In Power BI Using DAX
Creating Great Color Palettes for Power BI - Data Visualization Tips
Creating Compelling Dashboards With High Quality Insights In Power BI
Re-Using Moving Averages - Power BI & DAX Trend Analysis Technique
Profit Prediction Techniques in Power BI - Scenario Analysis w/DAX
How Does Sensitivity Analysis Work In Power BI - DAX Analytical Techniques
Reviewing Customer Performance Over Time - Power BI Insights
How To Download Latest Exchange Rates Into Your Power BI Model
Show Actual Results vs Targets Only To Last Sales Date - DAX Cumulative Totals
Who Are The Lost Customers - Advanced Analytics With Power BI & DAX
Allocating Results To Pre-Determined Templates - Fnancial Analysis In Power BI
Visualization Tips For Key Business Performance Indicators & Trends -
Show Difference To Forecast Up To Last Sale Date Only - DAX Technique In
Showcase Movement Within Custom Segments Through Time - Advanced Power BI
Monthly Budgeting Sensitivity Table Allocations - Power BI & DAX Analysis
How And When To Use PARALLELPERIOD In Power BI - DAX Function Review
Reporting Templates Expanded - Power BI Visualization Concepts
Automated & Dynamic Financial Reporting w/Power BI
Implement Cohort Analysis Within Power BI - Advanced DAX Concepts
How To Setup Application Like Reports - Power BI Reporting Techniques
Power BI Report Design Tips And Best Practices
How To Create Compelling Colour Palettes In Power BI
What Can You Do With Iterating Formulas In Power BI - DAX Review
Showcasing Growth Performance Effectively In Power BI - Advanced DAX
Cross Selling Matrix Deep Dive - Power BI & DAX Tutorial
Grouping Results Based On Performance vs Benchmarks - Power BI & DAX
Cumulative Totals Only Up To Specific Dates - DAX Tutorial For Power BI
Calculate The Last Or Max Value Within A Table Of Data Using DAX In Power BI
How To Manage Multiple Date Calculations In Your Fact Tables - Advanced Power BI
Calculate The Occupancy Days Per Month In Power BI Using DAX
Calculate A Monthly Moving Average Year To Date (YTD) in Power BI Using DAX
Iterating Functions Deep Dive - SUMX, AVERAGEX, MINX, MAXX
Creating a Custom Sort Order for Month Due to Financial Years
Visualize virtual tables
Last 4 weeks sales (or months) for each week (or month)
Grand Totals numbers not correct
Simulating an Epidemic using Python in Power BI
Importing data with new columns in power query
Using Two Date Tables To Do Analysis
Line & Stacked Column line not updating
Covid-19 - Calender setup for Pre-Post Lockdown analysis
4-4-5 Fiscal Year Calendar
What would the ultimate virtual Power BI training event look like?
Perfect way to format and now showcase your DAX formulas
DAX Clean Up tool - now up on website....try it out!
How to get previous month in power BI
Use of Power BI in Investment Banking or Fund Accounting
How to have cumulative total stop showing/repeating after reaching max cumulative total?
Help with Selective Application of What-If Parameters
PYTD Measure with Custom Fiscal (4-4-5) Calendar
DAX Balance Sheet Include Closing Balance
Power BI Workshop Announcement – Brand New Course Upgrade
How Can We Improve Our Ecosystems Functionality?
Meet the Enterprise DNA Experts
Complete Refresh For Ultimate Beginners Guide To DAX
Brand New Refreshed Content For The Ultimate Beginners Guide To Power BI
Check out the Enterprise DNA Knowledge Base
The Analyst Cloud Is Now Completely Free For Employers
Introducing Edna 1.0 Our New Educational Chat Bot
Three New Power BI Showcases Available at Enterprise DNA
Ways To Collaborate And Earn With Enterprise DNA
Updated Mastering DAX Calculations Course Now Officially Launched
Earn A Membership Program Spotlight
Announcing Our New Community Feature - Enterprise DNA Ecosystems
Course Completion Certificates Now Available At Enterprise DNA Online
New Customers in a given period
DAX measure - sum between two dates selected in the slicer
Factless fact tables
Ranking members within group
Accumulated Cash Flow DAX problem
Average days per month / transaction for a forecast
Add currently selected slicer selection to calculated table
Financial Dashboards
Count Open Cases
Cumulative Totals Not Working-
FX Transalation Financial Reporting
Power BI - Can I keep the original filter criteria after table interaction
Rank with Partition on different columns in Dax Query not working
Dynamic Ranking Matrix (by rows and columns)
Course wrap up - Thanks!
How to utilise Enterprise DNA content
Enterprise DNA Membership
Distribution features
Natural language query
Dashboards & Apps
Publish to online service
Visualisation best practices
Custom visuals in Power BI
Current Pricing And Purchasing Considerations
Where Has Power BI Come From?
Key Components Of Power BI
Power BI Desktop Features Explained
Power BI Online Service Features Explained
What Is A Data Model?
How To Understand DAX
DAX Function Types
Aggregation Functions
Iteration Functions
Table Functions
Calculate Function
DAX Patterns Intro
Table Functions: ALL
Percent Of Total - Simple
Percent Of Total - Context Considerations
Moving Averages - Simple
Re-Using The Moving Averages Pattern
Cumulative Totals - ALL
Cumulative Totals - ALLSELECTED
Cumulative Totals - Measure Branching
Time Intelligence Aggregations
Time Intelligence - Measure Branching
Percentage Change On Prior Period
Time Intelligence - Using Dateadd
Grouping Via Calculated Columns
Grouping Via Lookup Table Logic
Dynamic Grouping Via Support Tables
Dynamically Group Customers By Ranking
Sales And Orders In Progress
Introduction To Budgeting
Extending Budgeting Models
Introduction To Forecasting
Extending Forecasting Models
Introduction To Parameter Tables
Extending Parameter Tables
Fixing Errors With Parameter Tables
Relative Distinct Counts Explained
Introduction To Dashboarding & Data Visualization Intensive
My Visualisation Guide And Best Practices
How To Create A Colour Palette That Wows Fast
Dashboarding & Data Visualization Intensive: How To Approach
Consumer Good Sales Intro
Consumer Goods Sales Development
Customer Deep Dive Intro
Customer Deep Dive Development
Inventory Management Intro
Retail Sites Intro
Retail Sites Development
Scenario Analysis Intro
Scenario Analysis Development
Management Dashboard Intro
Management Dashboard Development
Employee Insights Intro
Employee Insights Development
Insurance Applications Intro
Insurance Applications Development
My Best Practice Tips For The Query Editor & Data Model
Why You Always Need To Use The Query Editor
What'S Possible With The Query Editor
How To Bring In Data To The Query Editor
Tips And Techniques To Work Through In The Query Editor
Understanding M Code
How To Fix Things If They Fall Over In Here
How To Organize The Query Editor Well
Column Transformations
Row Transformations
Filtering Tables For Unrequired Data
Creating And Modifying A Date Table
Staging Queries
Referencing & Duplicating Queries
Appending Queries
Merging Or Joining Your Queries
Unpivoting Your Tables
Columns From Examples
Custom & Conditional Columns
Creating And Using Parameters
Analytics Function For Power BI Scatter Charts Review
How To Use Natural Language Query (Q&A) In Power BI - Detailed Review
Why Measure Groups In Power BI Are So Important
Harvest Power BI Slicer Selections To Use With Other Measures - Advanced DAX
How to Use The ALL function in Power BI & DAX
Comparing Performance Using The ALL Function - Power BI & DAX
When & How to Use TOPN in Power BI - DAX Function Tutorial
Showcasing Top or Bottom Results Using Ranking Techniques - Power BI
Using ALLSELECTED - DAX Formula Concepts In Power BI
Using The CROSSJOIN Function In Power BI - DAX Concepts
Using LASTNONBLANK in Power BI - DAX Function Deep Dive
Using The AVERAGEX Function - DAX Tutorial & Examples
RANKX Considerations - Power BI & DAX Formula Concepts
Advanced Forward Forecasting Techniques in Power BI with DAX
Advanced Forecasting Logic in Power BI with DAX
Budgeting Examples in Power BI using DAX
Evaluating How You Can Make Budget - Power BI & DAX Scenarios
Dealing With Seasonal Budget Allocations in Power BI - Advanced DAX
Create Automatic Forecasts From Historic Data in Power BI using DAX
Create and Set Budgets Automatically In Power BI Using DAX
Showcasing Budgets Cumulatively In Power BI - Advanced DAX Formula
Advanced Product Budgeting Analysis - Power BI & DAX Techniques
The DATEADD Function - The Best and Most Versatile Time Intelligence Function in
What Is Measure Branching - Power BI Development Strategy
Best Practice Tips For Using The Advanced Editor - Power BI
Reviewing The Huge Potential Of The Q&A Feature In Power BI
'What If' Parameter Feature Review - Power BI & DAX
Calculating Sales Financial Year to Date in Power BI with DAX
Calculate Difference This Year vs Last Year in Power BI with DAX
Handling Multiple Dates in Power BI with DAX
Dynamically Compare Monthly Information Cumulatively in Power BI wDAX
Comparing Actual vs Budget vs Last Year Results in Power BI wDAX
Calculating Running Totals in Power BI Using DAX
Calculating Averages per Weekdays wDAX in Power BI
Calculate Amounts Sold Between Two Dates In Power BI wDAX
Handling Weekday vs Weekend Dates in Power BI using DAX
Calculating Month On Month Change - Custom (445) Calendars, Power BI & DAX
Calculate Previous Weeks Sales - Advanced DAX in Power BI
Year To Date Sales For Non Standard Calendar Tables - DAX in Power BI
Compare Time Periods With Non Standard Date Tables - DAX & Power BI
Show MTD, QTD & YTD Calculations To Current Date in Power BI wDAX
Calculate Transactions In Last N Days in Power BI Using DAX
How To Create Custom Financial Year Quarters - Power BI
Quarter On Quarter Sales Trends In Power BI - DAX Formula
Showcasing Trends Using Moving Average Techniques In Power BI
Prevent YTD, QTD, MTD Results Projecting Forward - DAX Techniques in Power BI
Calculating % Profit Margins in Power BI wDAX
How To Sort Date Dimensions By Custom Financial Years in Power BI
Solving in Power BI Which Products Have Contributed Most to Profit Growth using
How To Track Sales Trends Through Time in Power BI using DAX
Answer If Margins Are Expanding or Contracting Through Time With Power BI
Find Your Top Customers Through Time Using RANKX in Power BI wDAX
Find How Many Customers You Sell To Through Time in Power BI wDAX
Handling Multiple Currencies in Power BI wDAX
Find Lists Of Your Top Clients Across Different Measures w/DAX in Power BI
Dealing with Multiple Currencies in Power BI using DAX - Updated Version
Discover The Best Selling Day For Your Products w/DAX in Power BI
Find Your Top 3 Salespeople Per Region Automatically in Power BI using DAX
Learn Where Your Profit Comes From Fast in Power BI w/Simple DAX
Discover Top Salespeople Contribution To All Sales in Power BI w/DAX
Discover Your Top Products Per Region in Power BI w/DAX
Compare Stock On Hold To Recent Sales - Inventory Management in Power BI
Inventory Management Solution using Power BI
Explore Which Customers Margins Have Contracted in Power BI w/DAX
How Many Unique Products A Customer Bought - Power BI Using DAX
Analyse Procurement Purchasing Decisions in Power BI using DAX
Estimating Future Product Demand In Power BI Using DAX
Was Revenue Growth Profitable - Analysis In Power BI w/DAX
Did Margins Expand As Revenue Grew - Power BI & DAX Critical Analysis
Which Customer Groups Experienced The Greatest Growth - Power BI & DAX
How Much Profit Are We Missing Out On - Power BI Insights
Filtering By Fiscal Or Financial Year Months & Quarters In Power BI
Analyze Margin Changes Over Time - Analytics w/Power BI & DAX
How To Calculate Averages per Day in Power BI with DAX
Advanced DAX - Show Percentage Sales Per Custom Group Each Year In Power BI
Discover Which Custom Groups Contribute The Most To Profit in Power BI w/DAX
Calculating New & Existing Customer Sales Using DAX in Power BI - Advanced DAX
Testing The Pareto Principle (80/20 Rule) in Power BI wDAX
Identify Which Customers Are Purchasing Behind Trend in Power BI w/DAX
Evaluating Cross Selling Opportunities With DAX In Power BI - Advanced
Query Parameter Example in Power BI - Query Editor Tutorial
3 Best Practice Tips For Organizing Your Power BI Models
How to Create Virtual Groups & New Dimensions Fast in Power BI
Scale Your Power BI Reporting with Row Level Security
How To Use Variables in DAX Formula with Power BI
Review Of The New Power BI Feature - Quick Measures
How To Create A Detailed Date Table in Power BI Fast
Calculating Average Monthly Purchases in Power BI using DAX
The Art Of Storytelling In Data Analytics With Alex Badiu
Predict When Customers Will Purchase Next - Advanced Power BI & DAX
What's Causing The Change - Power BI & DAX Techniques
Detect Abnormal Patterns In Behaviour Using DAX In Power BI
What's The Most Common Behaviour From Customers - DAX in Power BI
Calculating Averages Per Transaction Using DAX in Power BI
Showcasing Deviations Effectively In Power BI - Analytical Techniques
Compare One Sale Versus The Last Sale (No Time Intelligence) - Advanced DAX
Custom FunctionsCustom Functions
Bringing Advanced Transformations Together
What Are We Trying To Achieve With The Data Model?
Best Practice Tips For Setting Up The Data Model
Setting Up Complex Models
What To Do If You Don'T Have A Lookup Table
Measure Tables / Groups
Intermediary Tables
Supporting Tables
Scenario Tables ('What If' Parameters)
Adding Dimensions To Lookup Tables
Multi Layered Models
Active Vs Inactive Relationships
How You Can Improve Your Models
How To Reduce The File Size Of Your Models
What Is Scenario Analysis?
Thinking Analytically About What You Want To Acheive
How To Implement It With 'What If' Parameters
How To Really Predict The Future With Scenario Analysis Techniques
Nuances Of Setting Up DAX Measures
Integrating 'What If' Parameters
Representing Changes To Your Variables
Project Numbers Forward With Time Intelligence Dax Techniques
Project Numbers Forward Using New Tables Of Data
Comparing Scenarios To Budgets Or Forecasts
Extending & Branching Out Scenario Analysis
Combining The Power Of The Data Model With Scenario Analysis
Running Multiple Scenarios At One Time
Scenario Sequencing - Maintain A Table Of Scenarios And Integrate All Values
Iterating Through Numerous Scenarios
Running Sensitivities On Multiple Scenarios
Solving For The Most Optimal Outcome
How To Visualize Scenario Analysis Results
Anomaly Detection
Cluster Analysis
Outlier Detection
Cross-Sell Opportunities
Pattern Recognition
Customer Segmentation
Threshold Triggers & Breaches
Secondary Table Logic
Advanced Power Bi Analytical Techniques - Pareto Rule
Customer Attrition
Dynamic Ranked Lists
Course Introduction: Financial Reporting W/Power BI
Power BI Model And Raw Data Review
Planning Your Data Model
Bringing Data Into Your Model
Query Editor Clean Ups And Transformations
Financial Reporting Data Structure Tips
Developing Your Data Model & Creating The Right Relationships
Integrating Tables Together
Organizing Your Model Well
Creating The First Dax Formulas For Your Model
Initial DAX Calculations
Dealing With +Ve/-Ve Numbers
Creating Rollup Subtotals Calculations
Embedding Financial Template Design Into Report Page
Overlay Main DAX Formula Combination To Template Design
Options For Template Designs And Visuals
Time Comparison Calculations
Other Template Calculation Possibilities
Managing Data At Different Granularities
Calculating Subtotal Amounts
Using Switch/True Logic For Template Design
Dealing With Unique Table Designs And Summary Calculations
Creating Summary Table Of Key Financial Ratios
Creating Initial DAX Functions For Report Breakdown
Calculating The Correct Summary Totals
Utilizing Switch/True Formula Techniques
Breaking Out Key Summary Lines Into New Tables
Creating Visuals When Dealing With -Ve Numbers
Reviewing Receivable Reconciliations
Modelling Considerations
Initial DAX Formula Requirements
Advanced Dynamic Grouping Modelling And Formula Techniques
Visualization Options
Dynamic Visualization Techniques
DAX Formula Implementation
Bring It All Together Showcasing Key Revenue Insights
Unique DAX Formula Combinations
Ranking Formula Techniques
Simple Visualization Tips
Colour Palette & Best Practice Visualization Techniques
Creating A Report Navigation Using Unique Icons And Bookmarks
Report Design And App Navigation: Wrap Up And Last Tips
Segment Data Based On Percentage Groups - Advanced DAX In Power BI
Inventory Management Development
When To Use TOPN In Power BI - DAX Formula Review
Calculating The Previous High Dynamically In Power BI Using DAX
Highlight The Last Or Current Period In Your Power BI Visuals Using DAX
The Main Difference Between ALL And ALLSELECTED - Power BI & DAX
Advanced RANKX - How To Understand This Function More Deeply
How To Create A Dynamic Headings In Power BI Using DAX
Calculate A Rolling Average In Power BI Using DAX
Create Unique Table Template Designs Within Power BI - Power BI &
Dynamically Group Receivables Based On When Cash Is Expected - Power
Time Based Cohort Analysis - How To Setup Your Data Model In Power BI
How To Use Virtual Tables With COUNTROWS in Power BI - DAX Formula Technique
Calculating Staff Turnover In Power BI Using DAX - HR Insights
Custom Conditional Formatting For Power BI Tables
Using The Performance Analyzer In Power BI - Model Optimization Tips
Calculating Dynamic % Of Total Changes - Power BI Analysis w/DAX
Actuals vs Budgets - Comparison Insights w/Power BI
Calculate Total CRM Forecasts From Today Until End Of Month - DAX Insights
Revenue Forecast Techniques For Project Data - Power BI Insights w/DAX
Calculate Days Of Zero Stock - Inventory Management Insights w/Power BI
Show Cumulative Totals Unaffected By Date Slicer Selection In Power BI
Why Using Variables Is A Better Way To Write DAX Measures - Power BI Admin
How To Use Iterating Functions To Solve Total Issues In Power BI - DAX Concepts
How And When To Use COMBINEVALUES In Power BI - DAX Function Review
Conditional Formatting For Chart Visuals In Power BI - What's Possible?
Cluster Analysis Visualization Techniques For Power BI - Power BI Review
How To Create Unique Subtotals In Power BI Tables Using DAX
Advanced RANKX - How To Understand This Function More Deeply
Outlier Detection & Visualization in Power BI - Advanced DAX
Addressing Granularity Issues - Intro To Problem of the Week #4 (Power Query)
Create A Dimension Table In A Text File - Problem Of The Week #2 (Power Query
Create A Dimension Table In A Text File - Intro To Problem Of The Week #2
Timesheet and Wages - Intro To Problem Of The Week #3 - (DAX Problem)
Perpetual Holiday Calendar - Problem of the Week #1 (DAX Solution)
Combinations and Permutations in Power BI
Creating A Custom Text Cleaning Function In Power Query
Level Up Your External Tools Menu In Power BI
Elevate Your Color Themes Via the Analyst Hub Community
Less Is More - Power BI Design Tips For Simple & Compelling Reports
X Axis Scaling with Date Table
Finding first min and second min
Again stuck with simple calculation
Dynamic % measure with multiple hierarchies in a matrix
Power BI Embedded RLS
Previous YTD Calculation
Simplify Cumulative formula
YTD with SelectedValue of Year Month Slicer
Variables in measures wrong results


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.


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


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.



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.


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

2 posts were split to a new topic: Pay Period End Date