Latest Enterprise DNA Initiatives

Asking Questions On The Enterprise DNA Support Forum

Please read through these rules and tips for asking questions on the forum before leaving any.


  1. We are determined to provide as much value as possible to all members on the forum but request that the forum not be used to ask for free consulting services or development work.

  2. Please break out separate questions into separate topics

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

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

  5. 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.

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

  7. If you find a solution to your questions before it is answered please let us know.

  8. 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.

  9. We encourage everyone’s participation in the forum, as such we don’t allow single calling out of a member to answer a question as this may discourage other users to help your inquiry.

  10. Please refrain from messaging experts and users in other platforms, like Linkedin, Facebook, email, etc to follow up your inquiries.

  11. Let us maintain respect inside the forum. No rude comment and no compelling anyone to answer your questions.


A ‘topic’ is like a support question
‘Categories’ are like the filing system for all the questions on the forum


  1. The questions should be very specific around any particular aspect of Power BI development, including formulas, models, analysis scenario etc.

  2. A question should be able to be answered within a maximum time of 20-25 minutes

  3. A question should provide every piece of detail possible to provide context for the person answering the query.

  4. The question should provide a demo model that can be utilised for testing to find the answer if required.

  5. A question that enables you to be guided to the correct solution using the comprehensive training content and resources provided by Enterprise DNA.


  1. Adding data and a model without any supporting information, like what you are trying to do or what formula you are using

  2. Asking a question you know could take hours of time to answer.

  3. Asking more than one question in any forum thread

  4. Asking question after question in the same forum thread around the same project or piece of development work.

Thank you all for your consideration around the above rules and tips for using the forum.

This will really help a lot in getting the correct answers to you in the shortest time possible and will also help others who may come across your question/s tomorrow, next month, or two years from now.

Join the forum and introduce yourself
Customer Retention Rate
Comparing New vs Lost vs Steady Customers over Multiple Years - Customer Churn Examples - Advanced DAX
How to create Template solution
Cohort Analysis Data Model Design Need Your Advise
What dax can you use to find activities on the same row?
Financial templates vsLastYear make sameperiod
Calendar for current month and future 11 months
Accounts System - Templates
PYTD Measure with Custom Fiscal (4-4-5) Calendar
Financial Reporting Balance Sheet with Same Headings Current V Non Current
New Customers in a given period
1 selector for multiple charts
Count of New & Exited Members by Channel FYTD
Drillthrough Question
Forecast to Actuals formula
First Purchase Date - DAX
Calculating the Churn Rate based on retained and churned customer
Visualize virtual tables
Basket Analysis with Support, Confidence and Lift
DAX calculation - v1
DAX calculation - v1
Measure calculates cumulative sales
DAX calculation - v1
Ranking members within group
Count unique customers in a status position given Start Date and End Date
Best Practice in getting data from an Excel file sourced in Sharepoint and refresh it from the PBI Service
Calculate the work hours between 2 dates( datetime) excluding weekends - 9 am - 6pm Mon-Fri
Calculate team head performance
Comparison code doesn't work?
Calculate optimal Product Mix
Calculating Customer Life Time Value (CLTV) From Cohort Analysis Show Case
Aged Debtors - no field to show item is paid or cleared
Long Time in Responding to forum Questions
Where to start to count historical date ranges on large volumes
TopN Dax doesnt seem to be working
Table Relationship or DAX Issue
Calculating Lost Customers
DAX for matching string and calculate TAT
DAX formula involving Variable and AverageX
Selecting 5 above and 5 below dynamically
Rank Unique - ranking when there are duplicate values
Average, Forecast, Target, To Reach Target
Cases Matrix of Top 3 Products for the Firm vs. all firms in same Industry (.pbix file is attached)
Comparable Bar Chart (Customer Vs Industry) by quarters
Need Help with DAX query
Percentages not giving me correct result
Incorrect Avg at the Client Level
Matrix YTD & Variance
Issue with this calculate and PREVIOUSDAY
Matrix YTD & Variance
RANKX avoid duplicate
SUM a Text Field
Need help with model
How get value line wise after subtraction of Credit Memo Amount from the total amount
Assign Number to A ranges of Dates
Improve performance of Cumulative formula

This post is part of the guidelines on how we can effectively utilize and manage the forum so all members can efficiently use it. To ask any questions please start a new topic within the forum.

9 posts were split to a new topic: DAX Switch Questions