Active Customers DAX – Solution
Active Customers DAX – SolutionActive Customers DAX – Solution
Active Customers DAX – SolutionIn this solution we explain how to calculate your number of active customers in DAX. An active customer is a customer which has transactions within a certain period. We show you how you can solve this problem in DAX with the best performing code.
[/su_column] [su_column size="1/2" center="no" class=""]
[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/Active-Customers-DAX-Intro.mp4"][/video]
[/su_column][/su_row]
Customer Retention DAX – Solution
Customer Retention DAX – SolutionCustomer Retention DAX – Solution
Customer Retention DAX – SolutionIn this solution we explain how to calculate the number of customers which are still creating sales for your company after the first transaction. So when you are investing in getting more customers you for sure are wondering how long that customers stay at your company and how many sales they generate for you. We also explain how you can analyze which products they buy.
[/su_column] [su_column size="1/2" center="no" class=""]
[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/Customer-Retention-Intro-www.powerbi-solutions.com_.mp4"][/video]
[/su_column][/su_row]
Datetable DAX – Solution
Datetable DAX – SolutionDatetable DAX – Solution
Datetable DAX – SolutionIn this solution we explain how you can create a datetable in DAX with the most common dimensions. Each datamodel needs a datetable to make sure you can apply time intelligence calculations and filter / visualize your data in the right way. This solution delivers you a ready to use datetable.[/su_column] [su_column size="1/2" center="no" class=""]
[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/Datable-Intro-www.powerbi-solutions.com_.mp4"][/video]
[/su_column][/su_row]
Datetable Fiscal Year DAX – Solution
Datetable Fiscal Year DAX – SolutionDatetable Fiscal Year DAX – Solution
Datetable Fiscal Year DAX – SolutionIn this solution we explain how to deal with a fiscal year in Power BI. We show you how to create a datetable which contains the right fiscal year, quarter, month, weeknumber etc. You can use this datetable to analyse, filter and visualize your data based on the right dimensions for your fiscal year.[/su_column] [su_column size="1/2" center="no" class=""]
[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/Datable-Fiscal-year-intro-2.mp4"][/video]
[/su_column][/su_row]
Driving Tables DAX – Solution
Driving Tables DAX – SolutionDriving Tables DAX – Solution
Driving Tables DAX – SolutionIn this solution we explain how you can create a dynamic report by using driving tables. These driving tables make it possible to change which data is shown in your visuals. So you can change for example your comparing figures from last year to budget with just one click. Driving tables are an alternative way to solve this instead of using bookmarks.
[/su_column] [su_column size="1/2" center="no" class=""]
[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/Driving-tables-www.powerbi-solutions.com_.mp4"][/video]
[/su_column][/su_row]
Lost Customers DAX – Solution
Lost Customers DAX – SolutionLost Customers DAX – Solution
Lost Customers DAX – SolutionIn this solution we explain how to calculate your number of lost customers in DAX. A lost customer is a customer which had transactions in the past and has no transactions within a certain period up till now. We show you how you can solve this problem in DAX with the best performing code. [/su_column] [su_column size="1/2" center="no" class=""]
[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/Lost-Customers-DAX-www.powerbi-solutions.com_.mp4"][/video]
[/su_column][/su_row]
New Customers DAX – Solution
New Customers DAX – SolutionNew Customers DAX – Solution
New Customers DAX – SolutionIn this solution we explain how to calculate your number of new customers in DAX. A new customer is a customer which has transactions within a certain period and has no transactions before that period. We show you how you can solve this problem in DAX with the best performing code.[/su_column] [su_column size="1/2" center="no" class=""]
[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/New-Customers-DAX-Intro.mp4"][/video]
[/su_column][/su_row]
Pareto Analysis DAX – Solution
Pareto Analysis DAX – SolutionPareto Analysis DAX – Solution
Pareto Analysis DAX – SolutionIn this solution we explain how te set up a pareto analysis in Power BI. The pareto in this example shows you the percentage of sales which is generated by an x percentage of customers. Besides that we created a drilltrough to show which customers are generating that x percentage of sales. [/su_column] [su_column size="1/2" center="no" class=""]
[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/Pareto-2-intro.mp4"][/video]
[/su_column][/su_row]
Returning Customers DAX – Solution
Returning Customers DAX – SolutionReturning Customers DAX – Solution
Returning Customers DAX – SolutionIn this solution we explain how to calculate your number of returning customers in DAX. A returning customer is a customer which has a transaction within a certain period and has also one or more transactions before that period. We show you how you can solve this problem in DAX with the best performing code.[/su_column] [su_column size="1/2" center="no" class=""]
[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/Returning-Customers-DAX-Intro.mp4"][/video]
[/su_column][/su_row]