Customer Retention Part 2: Period over Period Retention
Customer retention refers to the ability of a company or product to retain its customers over some specified period. There are many ways to measure the data. In the last blog (blog link), we have checked MoM (Month on Month) Retention. Here, we will go through Period over Period or POP.Power BI: Working with Non-Standard Time Periods
Power BI Time Intelligence functions provide a powerful way to get different types of time periods and time comparisons. Some of these are MTD, PMTD, PYMTD, MOM, MOYM, QTD, LQTD, QOQ, YTD, LYTD YOY etc. But dealing with a non-standard period can be a bit difficult, especially when months are not the standard months. In this article, we try to take on a case of non-standard periods (months).Distributing/Allocating the Yearly Target (Convert to Daily Target) -Part 1 - New Table
Whenever we have targets, typically, they're at the month or at the year level. All are other data like sales purchase is typically at the level. Now we want to analyze both these data together there is a challenge one data is at the year level another data is at the day level. To deal with such scenarios we have options of creating a day level table or creating a measure that can give us the Day level target. In this blog we are going to take the approach of creating a Table, that will provide us data at the day level.Power BI Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD)
Whenever we have targets, typically, they're at the month or Year level. All are other data like sales purchase is typically at the level. Now we want to analyze both these data together there is a challenge one data is at year level another data is at the day level. To deal with such scenarios we have options of creating a day level table or creating a measure that can give us the Day level target. In this blog we are going to take the approach of creating a Measure, that will provide us data at the day level.
