What you have described is how the logic has been set out in this tutorial. You can customize this further to whatever you like, it's understanding the technique which is the key here.

Hello OZVID, We're not in a position to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference about what's working and not working in your report or data model. We encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping you find this useful! If you haven't yet, you can subscribe to our KZfaq channel so that you won't miss out on any Power BI & Power Platform updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

@@EnterpriseDNA thank you so much for sharing the link, will do 🙏🙏

Hello Cauê, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. We're so glad that you're finding our content helpful!!! Well, did you checked the Edit Interactions option? In our case, we're just selecting a particular month and the table on the right is getting filtered automatically and nothing else. Well it's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference. And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping you find this useful. Also, make sure that you're subscribed to our KZfaq channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

sorry, just saw this, actually i have the same question, it does not correctly filter when clicking...

Hello Sai, Did you manage to find a solution to this one? Cheers,

Hi RM20, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. So the concept is like this - Let's say for example, you're on 31st December and you want to analyze the "Lost Customers". And the logic for lost customers is the customers who didn't purchased anything in last 2 months i.e., during the period from 1st November - 31st December but purchased during the period from 1st January - 31st October. And that's how the two variables are broken in that measure. The first variable analyzes the Customer Code who made purchases during the period from for example, 1st January - 31st October and second variable analyzes the customer code who're missing and did not made any purchases during the period from 1st November - 31st December. So then we make a comparison between the variables based on customer codes which are missing and then those missing customers are evaluated as lost customers. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful! You can subscribe to our KZfaq channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

Hello Gabriel, Thank you for posting your query onto our channel and we really appreciate you taking time to post it. Well, no the time slicer showcased into the report towards the left side is not a "Custom Visual". It's actually a standard Power BI slicer, the reason why you might not be liking it is because the "Responsive" option is turned-off under the format settings of the slicer. Just follow the steps as provided below and you'll also the slicer in your report as has been showcased into our video. Below are the steps provided for the reference - 1). Click on the "Slicer" to activate the slicer visual. 2). Under the "Format" menu, click onto the "General" option. 3). Disable the "Responsive" option. Once you follow this steps, you'll observe that your slicer will also look like the slicer as has been showcased into the video. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful. Also, make sure that you're subscribed to our KZfaq channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

@@EnterpriseDNA Thank you for taking the time to answer my question! It works great now!

Hello Stoneage8988, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well, you just need to ensure that the field which you're using from the table is linked with the other tables as well i..e, Fact Table linked with the Dimension Table. If you're using the fields from the Disconnected Table then it might not filter the results as expected. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful! You can subscribe to our KZfaq channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/ forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

I would like to know this to. YTD YoY YTD

Hello Nicholas Jeffries, thank you for posting your query onto our channel. Well, yes you can replace the 60 days and 365 days with the "DATEADD()" function in order to convert the calculation from "Days" to "Months". Below is the formula provided for reference - Calculation of Lost Customers - Lost Customers = VAR CustomersPurchased = CALCULATETABLE( VALUES( Sales[Customer Name Index] ) , FILTER( ALL( Dates ) , Dates[Date] > MIN( Dates[Date] ) - DATEADD( Dates[Date] , -1 , YEAR ) && Dates[Date] > MIN( Dates[Date] ) - DATEADD( Dates[Date] , -3 , MONTH ) ) VAR PriorCustomers = CALCULATETABLE( VALUES( Sales[Customer Name Index] ) , FILTER( ALL( Dates ) , Dates[Date] > MIN( Dates[Date] ) - DATEADD( Dates[Date] , -3 , MONTH ) && Dates[Date] > MIN( Dates[Date] ) ) ) RETURN COUNTROWS( EXCEPT( CustomersPurchased * PriorCustomers ) ) * -1 For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you'll find this formula useful and meets your requirements that you've been looking for. Happy Learning!!! forum.enterprisedna.co/

Hello fani, Thank you for posting your query onto our channel and we really appreciate it. Well, the method used under the measures for "Attrition Value" and "Attrition Sales" is a "SWITCH( TRUE () )" statement. That is, under the measure attrition value, these are the measurs used - "New Customers" & "Lost Customers" and under the measure attrition sales, these are the measures used - "New Customer Sales" and "Customer Revenue Lost". Below are the measures for each of these metrics provided for the reference - New Customers = VAR CustomerTM = VALUES( Sales[Customer Name Index] ) VAR PriorCustomers = CALCULATETABLE( VALUES( Sales[Customer Name Index] ) , FILTER( ALL( Dates ) , Dates[Date] > MIN( Dates[Date] ) - 30 && Dates[Date] < MIN( Dates[Date] ) ) ) RETURN COUNTROWS( EXCEPT( CustomerTM , PriorCustomers ) ) Lost Customers = VAR CustomersPurchased = CALCULATETABLE( VALUES( Sales[Customer Name Index] ) , FILTER( ALL( Dates ) , Dates[Date] > MIN( Dates[Date] ) - 365 && Dates[Date] < MIN( Dates[Date] ) - 60 ) ) VAR PriorCustomers = CALCULATETABLE( VALUES( Sales[Customer Name Index] ) , FILTER( ALL( Dates ) , Dates[Date] > MIN( Dates[Date] ) - 60 && Dates[Date] < MIN( Dates[Date] ) ) ) RETURN COUNTROWS( EXCEPT( CustomersPurchased , PriorCustomers ) ) * -1 New Customer Sales = VAR CustomerTM = VALUES( Sales[Customer Name Index] ) VAR PriorCustomers = CALCULATETABLE( VALUES( Sales[Customer Name Index] ) , FILTER( ALL( Dates[Date] ) , Dates[Date] > MIN( Dates[Date] ) - 30 && Dates[Date] < MIN( Dates[Date] ) ) ) RETURN CALCULATE( [Total Sales] , EXCEPT( CustomerTM , PriorCustomers ) ) Customer Revenue Lost = VAR CustomersPurchased = CALCULATETABLE( VALUES( Sales[Customer Name Index] ) , FILTER( ALL( Dates ) , Dates[Date] > MIN( Dates[Date] ) - 365 && Dates[Date] < MIN( Dates[Date] ) - 60 ) ) VAR PriorCustomers = CALCULATETABLE( VALUES( Sales[Customer Name Index] ) , FILTER( ALL( Dates ) , Dates[Date] > MIN( Dates[Date] ) - 60 && Dates[Date] < MIN( Dates[Date] ) ) ) RETURN CALCULATE( CALCULATE( [Total Sales] , DATESBETWEEN( Dates[Date] , MIN( Dates[Date] ) - 365 , MIN( Dates[Date] ) - 60 ) ) , EXCEPT( CustomersPurchased , PriorCustomers ) ) * -1 Apart from the above measures which are being provided, we're providing few of the links of the articles from our blog posts as well as links of the videos from our Enterprise DNA KZfaq channel pertaining to this topic i.e. Attrition Analysis as well as SWITCH( TRUE() ) statement in Power BI. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful and meets your requirements that you've been looking for. Also, make sure that you're subscribed to our KZfaq channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/ blog.enterprisedna.co/analyze-who-your-lost-customers-are-using-power-bi-dax/ blog.enterprisedna.co/customer-attrition-analysis-advanced-dax-in-power-bi/ blog.enterprisedna.co/new-vs-existing-customers-advanced-analytics-w-dax/ blog.enterprisedna.co/deep-dive-into-the-calculatetable-function-an-important-dax-formula-to-understand-well/ medium.com/@sam.mckay/analyze-customer-attrition-using-power-bi-f8207d50b98a blog.enterprisedna.co/using-advanced-dax-for-multiple-if-statement-in-power-bi/ blog.enterprisedna.co/using-switch-true-logic-in-power-bi-dax-concepts/ community.powerbi.com/t5/Community-Blog/SWITCH-True-Logic-In-Power-BI-What-s-Possible-With-This/ba-p/509753 kzfaq.info/get/bejne/j9OpbJSIl7GRdX0.html kzfaq.info/get/bejne/np-bhdqYxtOwk6s.html kzfaq.info/get/bejne/fbFdipVmt7OcZ4U.html kzfaq.info/get/bejne/opeGd5tqvtfKf2g.html kzfaq.info/get/bejne/i9lxfbN6prSlkmw.html

Hi Mayra, for help like this check out the Enterprise DNA Support Forum - forum.enterprisedna.co/search?q=Syntax%20Countrows

Hello Abhishek, Thank You for posting your query onto our channel. Yes, this is definitely possible to convert the day wise analysis onto the month wise analysis. But it's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference. And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping you find this useful. Also make sure that you're subscribed to our KZfaq channel so that you don't miss out on any updates pertaining to the Power BI. Happy Learning! Thanks and Warm Regards, Enterprise DNA forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA

Hello Beatriz Oliveira, Thank you for question. We appreciate your time. It is a little difficult to tell and provide the results without looking at the data structure, model and working of the PBIX file. So we encourage you to please write back to us to our Community Forum by providing a thorough description of the problem that you're having along with the PBIX file you are using as reference, as well as the mock-up results that you're trying to achieve. Our members and/or experts team will be able to assist you in a better and efficient manner. I have provided the link to our forum below: forum.enterprisedna.co/ For more queries, you can also reach out to us through our Community Forum where our members as well as Experts Team will be able to assist you, in a better and efficient manner. I hope this helps. Please make sure that you're subscribed to our KZfaq channel so you don't miss out any updates regarding Power BI. Along with it, you may also be interested to join our Power BI group on LinkedIn to receive latest updates. Links provided below for your reference. Happy Learning!!! Thanks and Warm Regards, Enterprise DNA forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

Hello Panagiotis Diamantis, thank You for posting your query onto our channel. Well yes, with this they'll appear it as a lost customer since the logic behind this is "If a customer don't make any purchase in last 2 months then they're considered as a lost customer" and after 2 months when they make a purchase they're considered a new customer. If you want to have dynamic selection where you want to define your own period that if customer don't make any purchase with us within that period than they should be considered a lost than for this as well we have videos available onto our KZfaq channel. Below are some of the links provided for the reference in relation to the "Churn Analytics" topic. You can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link provided of our Forum for the reference. Hoping you find this useful and meets your requirements that you've been looking for.🙂 Happy Learning!!! kzfaq.info/get/bejne/np-bhdqYxtOwk6s.html kzfaq.info/get/bejne/j9OpbJSIl7GRdX0.html kzfaq.info/get/bejne/oMWHgauIzZnHhX0.html forum.enterprisedna.co/

Hi Bryce, for help like this check out the Enterprise DNA Support Forum - forum.enterprisedna.co/search?q=Churn%20Analytics

Hi Scott, PBIX file is available in Enterprise DNA Online: portal.enterprisedna.co/

@@EnterpriseDNA Hi Sam, I did sign up for a membership and I was able to find the PBIX file and download it. Is it possible to enhance this so that it won't show the same "lost" customer month after month? In other words, only show the customer when he first gets to the lost status, but not after that.

@@scotth4514 I see someone has encountered same problem I have. I've searched around for the answer and haven't found an answer. Did you?

I didn't file the PBIX file can u help me to get the file thanks

Just use a WhatIf Parameter, then link the 60 days of the Formula to that parameter