Thank you so much. Well explained. I am a beginner and i did some mistakes like closing brackets and all but eventually i made it.
@redguard314
2 жыл бұрын
Thank you so much for explaining and walking us through your DAX examples! It is very easy to follow.
@MITutorials
2 жыл бұрын
You're very welcome!
@thanomnoimoh9299
10 ай бұрын
Thank you for your clip that simply to understand , Great!!!
@rajeshwarraodugyala8482
2 жыл бұрын
easy and simple explanation. informative
@federicourena8459
Жыл бұрын
Thank you so much! I have tried to copy the formula, but I kept getting an error when the last part of this section is added. "ALL('DIM_DateTable'[Date],DIM_DateTable[Date]
@ravindrasinghsuri8299
6 ай бұрын
Hi MITutorials, Thank you for this, is it possible to share the which customer is a new customer?
@JayantShettigar-pt6uo
5 ай бұрын
Awesome
@bhargavi_data_analyst
11 ай бұрын
Excellent!!!
@WaqasGulll
Жыл бұрын
Thank you sir for sharing this precious learning. I have a request, how can we get lost customers based on slicers(Year and MonthName from calendar) If 2023 selected so the table will show customer name, New customer sales which start sales in 2023. Repeat customers sales which were available in previous months and years also. Lost customers sales which were available in 2023 but when i select 2023 then table can show these customers previous sales in negative to know how much sales we lost in current period of which customers?
@mssnowy2071
Жыл бұрын
Thanks
@lataloungani
2 жыл бұрын
Thank you for sharing. What's the definition of new customers in this case ? Customers who have not visited during the year (12M) or works backwards from the date selected to 365 days ? Ex: if we are in the first month of the year, let's say Jan. Does it consider all customers who have not visited from Feb last year to Jan this year or only Jan ? Also, it would be helpful to understand lapsed customers i.e. customers who visited in past years and have returned after a gap of 1 year or 2 years.
@MITutorials
2 жыл бұрын
This is basically looking at the entire data and returning whether it is a new customer or not. If you need to add the timeframe to this you will have to tweak the variables 'Current Customers' & 'PastCustomers' so that they will look into that particular time frame and return whether the customer is old or new.
@lataloungani
2 жыл бұрын
@@MITutorials Thank you. Do you have a tutorial for customized date selection please ?
@dataanalyst8044
2 жыл бұрын
hai, thanks you for the tutor, you save me a lot, how about lost customer, can you give tutorial.
@jayantsenguptarock
Жыл бұрын
How can i calcualte Lost Customers from these measures.
@jayantsenguptarock
Жыл бұрын
Thanks to you for making it easily understandable 😄 I have a quick doubt. If we divide Old Customers by Total Customers, we'll get the Retention Rate right ?
@MITutorials
Жыл бұрын
Yes, correct
@gagansingh3481
Жыл бұрын
How we calculate the old, new , retained customer for last 30 , 90 ,180 days can you please make a video and days we can dynamically change it ..Sir
@jayantsenguptarock
Жыл бұрын
Hi. Its only working when I'm selecting a particular year. I've marked all years and now "New Customers" is showing up as same as "Total Customers" & "Old customers" is coming up as 0. Anyone have any idea why is it happening ?
@MITutorials
Жыл бұрын
When you select all years , what do you want to compare with ?
@jayantsenguptarock
Жыл бұрын
@@MITutorials I would like to compare it with the previous years. If selection is 2017 then it should compare it with 2014.15 and 16.
@carlosalcarezabeille
2 жыл бұрын
thanksssssssssss
@neerajraut2234
Жыл бұрын
I am applying the same formula for my project, but the total no. Of customers and new customers both values are same and that's why the value of old customer is 0... I have the data of only one year,,, how am i supposed to solve this?
@MITutorials
Жыл бұрын
You must be missing some step in between. Please follow the tutorial carefully.
@neerajraut2234
Жыл бұрын
@@MITutorials yes sir it is working, but it is only showing in tables , not in cards or multi row card,,, but eventually it really helps.... Thankyou for this video
@irfandaud7380
2 жыл бұрын
Nice. Created Data from July 21 to Dec 21 and Date table as well. When i use the Measure for No. of New Customer, (First Month, July 21) customers are shown as new customers. However, in your work, For January 2020. No. of new customers are Zero. How?
@MITutorials
2 жыл бұрын
I have previous years of data as well which was filtered. The first month must always show as new customers!
@irfandaud7380
2 жыл бұрын
@@MITutorials Thank You
@r_a_j_d_e_e_p_c
Жыл бұрын
Please send the link "How to create a calendar table from a customer table"?????
@MITutorials
Жыл бұрын
How to Create Calendar Table using DAX in PowerBI | MI Tutorials kzitem.info/news/bejne/sJ16loKghJeId4o
@jnorth78
Жыл бұрын
Liked and Subscribed! Would love to know how I can leverage this to get "Active Accounts" in the last 90 days
@MITutorials
Жыл бұрын
Need a bit more details - How do you identify the Active accounts?
@jnorth78
Жыл бұрын
@@MITutorials if an account has had a sales order within the past 90 days. Id love to show the count of customer accounts that have placed an order within the past 90 days as reportable figure along with this DAX you’ve done
Пікірлер: 35